04-26-2006 10:15 PM
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
04-26-2006 10:21 PM
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 thisll give you some idea.
Thanks
Saquib Khan
04-26-2006 10:21 PM
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 thisll give you some idea.
Thanks
Saquib Khan
04-26-2006 10:32 PM