topic Security tables for roles and authorization objects with feilds ? in Application Development and Automation Discussions

Security tables for roles and authorization objects with feilds ?

Former Member — Wed, 26 Apr 2006 21:15:18 GMT

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

Re: Security tables for roles and authorization objects with feilds ?

former_member181966 — Wed, 26 Apr 2006 21:21:18 GMT

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

Re: Security tables for roles and authorization objects with feilds ?

Former Member — Wed, 26 Apr 2006 21:32:43 GMT

Thank you so much

Bye