Security Table

[Former Member]

Hi All,

We are planning to implement row level security using the security or user table.

1) Added Security table in the universe and joined to related table

2) Created a predefined condition: UserID = @variable('BOUSER') and applied on the Universe

Question : I need to implement a logic where If the user is not in the security table then he/she has to see everything ( No Security ) on the data.

Example : I am a developer/ Admin and need to see every data and I am not in the Security table.

Please share some thoughts.

Basic model :

www.youtube.com/watch?v=X9DJuV0_vY4

Thank you

[former_member182521]

Hi Linda,

This should good enough to suit your requirement. Have a look. The thing is that you need to implement this at universe level and use UserID = @variable('BOUSER') syntax.

http://www.trustedbi.com/2007/11/06/row-level-security-trick-with-crystal-reports/

Regards,

Mani