How to find Composite assigned to a Deleted a User

[Former Member]

Hi

We have deleted a User some time back. Now we want to re activate the user with same access which was earlier. Through ' Change Document for Users' in SUIM / SU01 , the istory shows the list of Single Roles (which were part of Composite roles assigned to User earlier). But we want to assign the same composite roles which were assigned earlier (rather than SIngle roles).

Is there any way to find the corresponding Compostie Roles which were assigned to user prior to deletion (It will be very time consuming and Difficult to find out the Composite orles from the list of CM roles)

Thanks in advance.

[Former Member]

Hi Vitthal,

check table AGR_AGRS. find out the composite role names and assing to the user.

Regards,

Chaitanya.

[Former Member]

Thanks Krishna for the reply

But the Table AGR_AGRS gives all the available Composite roles for listed CM roles

[Former Member]

Hi Vitthal,

Please check USH* tables like USH02, USH04 ...for Change history.

refer to this thread :

Regards,

Chaitanya.

[Former Member]

Thanks again Krishna

But none of these tables gives the Required information

[Bernhard_SAP]

Hi Vitthal,

first of all don't use change documents for users, but change documents for role assignements (t-code RSSCD100_PFCG_USER). In the result list you'll have all the roles which had been assigned/removed.

Now save the list of roles locally (for instance in an excel).

Then go to SE16->table agr_agrs.

Press the 'multiple selection' button right to the selection field 'AGR_NAME'. The popup for multiple selections appear.

Now copy the role list and paste it into the selection (button 'copy from clipboard').

As single roles are not contained in the field agr_name, you'll get only composite roles now from SE16. Now you have the list of composite roles only....

That's it.

b.rgds, Bernhard

[Former Member]

Thanks Bernhard for the solution

Points awarded