If no objects are selected from the test sales table, will the row level security still gets applied. Suppose if we want that any object user takes in the report query, for example Product from products table, he should be seeing products related to him.
Good question. In your case, you can select filters to be applies on whole universe. Users can select any object and row-level security would be imposed.
aroundBI I think generally this would be the requirement for reports. Could you please explain with your experience how row level security is advantageous over row level security?
Sure, I will try my best to help you out. I guess there is something missing in your question. do you want to compare row level security with object level security?
No I want to compare row level security to universe level filter(Pre defined filter) as you mentioned above that " In your case, you can select filters to be applies on whole universe. Users can select any object and row-level security would be imposed." I hope I am clear. Thanks for your patience.
Very informative...keep uploading videos on important concepts like this. I am still waiting for your video on loops and contexts.
When will you upload row level security in IDT - Security editor?
Hi,Very well detailed explanation,could not find anything on Security Editor (Business & Data security profiles) can you please send me the links
Can you please share the security editor -idt tool video as well?
If no objects are selected from the test sales table, will the row level security still gets applied. Suppose if we want that any object user takes in the report query, for example Product from products table, he should be seeing products related to him.
Good question. In your case, you can select filters to be applies on whole universe. Users can select any object and row-level security would be imposed.
aroundBI thanks for replying. Great tutorials on concepts.
aroundBI I think generally this would be the requirement for reports. Could you please explain with your experience how row level security is advantageous over row level security?
Sure, I will try my best to help you out. I guess there is something missing in your question. do you want to compare row level security with object level security?
No I want to compare row level security to universe level filter(Pre defined filter) as you mentioned above that " In your case, you can select filters to be applies on whole universe. Users can select any object and row-level security would be imposed." I hope I am clear. Thanks for your patience.