Row level security based on users email
I have a SQL table in my data source, the table details the user IDs and email addresses, and a bunch of other things the user is allowed to see. What I'd like to do is apply row level security dynamically, such that when someone logs in to Sisense, the data is restricted according to the email address of the user as held in Sisense, without having to create a rule for every single user, or need to add new rules when a new user is created.
Is this possible in Sisense?
-
I don't think that would be possible out of the box, but that should be possible by creating an small external procedure to automatically create such rules. If you would like to discuss details of that please feel free to reach out to me at michael.becker@qbeeq.pl
Please sign in to leave a comment.
Comments
1 comment