09-10-2007 8:31 AM
Wed like to know the ACTIVITY USE OF AUTHORITY which gave the users.
E.g. weve had data from the Audit log (SM20) And now wed like to have data which realize by SU01 and which could be to scan per SUIM, ING-operation (S_BCE_6800*).
That would be a wonderful if we can know how to extract such data Can someone please help me with it? WHAT IS THE TABLE OR REPORT CONTAINS FULL AUTHORITY OF USER?
09-10-2007 8:43 AM
i don't understand your question fully, but the link between users and roles is in the table AGR_USERS , and the link between authorisations and roles are in AGR_1251 .
09-10-2007 9:48 AM
THERE IS NO SINGLE TABLE WHERE YOU CAN GET THIS INFORMATION
You can get this info from USR04, USR10 and USR12, however it is not in a very readable format. You can also use the UST* versions of the above tables, however I believe these can be inaccurate at times.
As Dries has said, you can use AGR_USERS and AGR_1251 - these report at the role level rather than the profile level (access is provided by the profiles) though for your purposes, they are probably more suitable than the USR tables
09-10-2007 11:05 AM
09-10-2007 2:10 PM
You can also run SU56 - there is an icon for other user. This will give you all of the auth objects and values that are in the user's buffer.
09-10-2007 3:15 PM
I think those values are stored in table USRBF2 but haven't checked it out.