Security tables for roles and authorization objects with feilds ?

[Former Member]

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

[Former Member]

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

[former_member181966]

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

[Former Member]

Thank you so much

Bye

UA