Helpful tips

Which table holds composite single roles relationships?

Which table holds composite single roles relationships?

AGR_AGRS is a standard SAP Table which is used to store Roles in Composite Roles data and is available within R/3 SAP systems depending on the version and release level.

What is single role and composite role in SAP?

Composite roles can simplify the user administration. They consist of single roles. Users who are assigned a composite role are automatically assigned the associated single roles during the compare. You can create a composite role and assign it to the users instead of putting each user in each required single role.

How can I see Roles in SAP?

As you can see the SAP transaction /PERSOS/ADMIN_UI is a part of /PERSOS/ADMIN_ROLE Admin UI role. Double click on the role to go to its definition and to see assigned users for the target role.

How do I remove a single role from a composite role in SAP?

Report as offensive (i.e. containing spam, advertising, malicious text, etc.)

1. Download AGR_AGRS for the 800 roles to Excel and take out the role to be deleted.
2. Create an ECATT script which deletes all singles from a composite and run this on your list of composite roles.

What is Pfcg role in SAP?

PFCG is a role maintenance administration to manage roles and authorization data. The tool for role maintenance, the Profile Generator automatically creates authorization data based on selected menu functions.

What is single role and composite role?

How do you add a single role to a composite role?

Goto tcode PFCG and enter a role name for composite role and we have following 2 single role which we used it for creating composite role. 4. Click save and finish composite role creation and that’s it you have done it.

How do I list all roles in SAP?

Listing all User name with respective assigned Roles in SAP system and exporting the data to local file

1. Step1: Login to the system and client from which you need to get the lists.
2. Step2: Run the transaction SE16 – Data Browser and enter table name ‘AGR_USERS’ and click on ‘Table Contents’ button.

How do you delete a composite role?

It seems I solved the problem on my own:

1. Create the transport of the composite role still containing the single roles.
2. Remove the single roles from the composite role.
3. Delete the composite role.
4. Delete the single roles.
5. Release the transport.

How do I delete a role in SAP mass?

Tcode SCAT and record PFCG with delete option of a role. Then find the field from the test case and create a parameter for that. Export default variant. Then edit this file by entering the roles you want to delete.