User - Transaction codes - Authorisation objects and activities report at

[Former Member]

Hi ,

Is there any standard report which give me all data at a glance for Username -- authorisation for transaction codes , authorisation objects and activities given to the user ?

I have SAP 4.7 version. Is there any function module for the same ?

I am writing z report but I lot of difficulties .

I want this reports for all my prd users with all details.

Please guide me on this ? Is anybody have written Z reports for this ?

Thanks

Milind .

[Former Member]

Hi,

You will certainly learn a lot by running the reports in txn SUIM and also by tracing them and examining the ABAP code. To get you going, here are a few tables you'll probably find interesting:

User -> profiles: table UST04

Composite profile -> single profile: UST10C

Single profile -> authorization: UST10S

Authorization -> object/field values: UST12

With roles it's even easier:

Users -> roles: AGR_1251

Roles -> authorization values: AGR_1251

Two things to keep in mind:

1) SAP is free to change its data model in future releases, so you may have to adapt your Z program in future releases

2) Read tables but don't change them!

Have fun,

Mark

[Former Member]

> With roles it's even easier:

> Users -> roles: AGR_1251

> Roles -> authorization values: AGR_1251

>

Correction:

Users -> roles: AGR_USERS

Roles -> authorization values: AGR_1251

[Former Member]

Thanks Mark .

How to read USR10 table field auth . Its long character .

How can I get all required profiles / authorisation objects / classes etc for a given transaction code .. Can you please elaborate the path ?

Thanks .

Milind.

[markus_doehr2]

This is not only one table. There are several tables involved. I can't give you all the function modules that need to be called (I'm not a developer anyway).

There's a table with profile and roles (as already mentioned in the thread), there are permissions related to them. I wonder why you try to re-code the whole SUIM

After the next support package your program might not work any more.

Markus

[Former Member]

Hi Milind,

USR10 is trick to handle because of the long field. Use UST04 instead as mentioned in my original reply.

Rgds,

Mark

[markus_doehr2]

> Is there any standard report which give me all data at a glance for Username -- authorisation for transaction codes , authorisation objects and activities given to the user ?

Transaction SUIM?

> I am writing z report but I lot of difficulties .

>

> I want this reports for all my prd users with all details.

If that above is not sufficient enable SQL trace in ST05 and see which tables are accessed.

Markus