Row-Level Security with Initial SQL

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ส.ค. 2024
  • Tableaufans Post: tableaufans.co...
    Manoj's Blog Post: sqlwithmanoj.c...

ความคิดเห็น • 5

  • @tableaututorialstips71
    @tableaututorialstips71 ปีที่แล้ว

    Thank you Great information :)

  • @SamCh-zg6vk
    @SamCh-zg6vk 4 ปีที่แล้ว +3

    Could you please let us know if this would work for extract mode? Or do we have different way to leverage the RLS setup at SQL server end and in Tableau data sources in extract mode?

  • @bairamsunil
    @bairamsunil 4 ปีที่แล้ว

    The video is really good, I liked the way you represented, I am going to view Manoj blog as well for a better understanding, I have a question regarding the same.
    1. I have a table of contents which have links to connect based on product category.
    2. I want to show specific links of TOC based on user privileges, can you shed some light on how to do that.
    Thanks you
    Bairam

  • @arunkumar2029
    @arunkumar2029 4 ปีที่แล้ว +1

    I have 2 separate questions:
    1. How would the data behave if I use a parameter to pass the username to qualify certain rows through Initial Sql and setup a temp table. Finally querying from that table by Custom Sql. Then if I use Live custom Sql vs extract. How would this affect on the server?
    2. If I did publish it as an extract and another user opens it. Will the initial Sql run one time to setup a temp table to get only records matching that particular user?

  • @TimRubel
    @TimRubel 4 ปีที่แล้ว

    Great overview!