Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Security tables for roles and authorization objects with feilds ?

Former Member
0 Kudos

Hello Experts

I am writing a report for security, I want to find security object and value with given roles, and also user attached with the roles. Can any body help me in this regard?

Cheers

Usman

1 ACCEPTED SOLUTION

former_member181966
Active Contributor
0 Kudos

Usman,

You can use tables AGR_1251 and AGR_USERS . AGR_USERS has roles with user name where as table AGR_1251 has roles with authorization objects and value .

For example ,

If you say you want to find out personal sub area in HR with specific sub area # like 8001

You can go to AGR_1251 and object will be P_ORGIN , field = persa ( Sub area ) and value = 8001.

Hope this’ll give you some idea.

Thanks

Saquib Khan

2 REPLIES 2

former_member181966
Active Contributor
0 Kudos

Usman,

You can use tables AGR_1251 and AGR_USERS . AGR_USERS has roles with user name where as table AGR_1251 has roles with authorization objects and value .

For example ,

If you say you want to find out personal sub area in HR with specific sub area # like 8001

You can go to AGR_1251 and object will be P_ORGIN , field = persa ( Sub area ) and value = 8001.

Hope this’ll give you some idea.

Thanks

Saquib Khan

0 Kudos

Thank you so much

Bye

UA