How to find Simple role

Question: Hello,

we would like to find simple role which has been attached to which composite role?

Example : we have simple role named abc and more than 50 to 60 composite roles. Now we want to know that "abc" simple role has been attached to which composite roles.

your help would be appreciated.

Thanks & regards,
jimmy

Answer:
Hello Jimmy,

You can find this information in table AGR_AGRS.

Alex

Answer:
Hello Alex,

Thanks for the help.

Can we find the simple role contained in composite role thru GUI, I mean to ask, can we find thru any transaction code?

one more question:

We have created one communication or service user. How can we find the missing authorisation for that user?

your help would be great to me.