Skip to Content
0
Former Member
Apr 18, 2014 at 07:34 AM

Question on Universe Security implementation

56 Views

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