Security tables for roles and authorization objects with feilds ?
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?
Saquib Khan, PMP replied
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.