Hello,
We have a requirement to implenet rsecurity based on a security table at the DB side. We will be joining the security table to out facts and then will create one filter which will point to the security table and will be applied on the whole universe.
Filter condition:
Security_table.USERNAME =@Variable('BOUSER').
The reason we are going with this approach is, If we define row level restriction then we need to get atleast one object from this security table which we dont want to do.
But the challenge here is we dont our admin users to be part of this security table. When an Administrator logs in we dont want the security table to be used in the query. Any approach for this issue.
Thanks,
Laxmi