on 05-07-2013 9:28 PM
Please advise, I know we can implement row level security using security table with @Variable("BOUSER").
My question here is , If it possible to apply data security on LOV, So when a user runs a report it should prompt only the LOV's related to him ??
I believe the row level security at the Universe level itself should take care of the LOV's as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would suggest try it at your end for one object and see if it works. You can refer the following thread on how to create the row level security.
Hi RUC
You can restrict LOV's by row level security in universe with following steps.
1. Go to Tools - Manage security - Manage access restrictions.
2. Create new restriction set.
3. In 'Rows' tab, click on add then select the associated table of that object and mention where clause with 'list of values'
4. add the usergroup/user in the right side (Manage access restrictions window).
5. Finally Apply newly created restriction in left side with above user group/user in right side.
6. Export the universe.
7. If you create the prompt for the above object then it will display only the above LOVs for the respective user or for the users added in above group
Hope this helps.
------
Kishore Balachandran
The rules of engagement require to search before posting, please do so next time or we end up with the same questions over and over...
thanks for your co-operation
best regards
Simone Caneparo
SCN Discussions Moderator
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.