Row level securtiy with cascade RRS feed

  • Question

  • I am currently looking into the Probelm of Row Level secuirty with a cascading responsability structure.

       B       C
     D E     F G

    D, E, F and G should only see data that concern them. I can do this via the USERNAME() function.

    B should see his data plus D and E, C should see his plus F and G

    A should see everything.

    I can get the responsabilities with a recursiv SQL, but I have no idea what the most Logical way would be to build up the table and how to implement the Row Level security for cases B, C and A.

    Can somenbody help?

    Tuesday, February 13, 2018 8:22 AM


All replies