Hi All,
I have a senario.I want to create row level security so that if the user belong to one group should only see their group data.when i am adding row level in supervisor it is filtering if the group table is selected and it is not appending the condition to all the quries.But i want the condition to be appended for every query the user makes.how can we achieve this
You’ll need to provide greater specifics about which tables are joined to which, and where you want the restrictions applied. But most likely, at the very least, you’re going to have to modify your universe in Designer to force Table X (the group table?) to be used with each object in Table Y (the fact table) – by using the “Tables” button on the bottom of each object that you want to force.
I am moving this topic from “Security and User Administration” ==> Supervisor (4.x -6.x) to the “Semantic Layer” forum, because that’s where the discussion should most likely continue.