cancel
Showing results for 
Search instead for 
Did you mean: 

Row level security on LOV

former_member203645
Active Participant
0 Kudos

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 ??

Accepted Solutions (1)

Accepted Solutions (1)

former_member189638
Active Contributor
0 Kudos

I believe the row level security at the Universe level itself should take care of the LOV's as well.

former_member203645
Active Participant
0 Kudos

Thanks for the input !!

Can someone confirm ??

former_member189638
Active Contributor
0 Kudos

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.

http://scn.sap.com/thread/3242268

Former Member
0 Kudos

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

Answers (1)

Answers (1)

former_member188911
Active Contributor
0 Kudos

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