topic Re: Which user has which authorizations in Application Development and Automation Discussions

Which user has which authorizations

Former Member — Fri, 26 Dec 2008 09:54:10 GMT

Hi all,

I need to know which user has which authorizations.

In which tables can I find these data?

Thanks.

deniz.

Re: Which user has which authorizations

Former Member — Fri, 26 Dec 2008 09:55:48 GMT

UST04

Edited by: SURINDER SINGH OBEROI on Dec 26, 2008 3:28 PM

Re: Which user has which authorizations

Former Member — Fri, 26 Dec 2008 09:56:57 GMT

Hi,

USR02

Logon data

USR04

User master authorization (one row per user)

UST04

User profiles (multiple rows per user)

USR10

Authorisation profiles (i.e. &_SAP_ALL)

UST10C

Composit profiles (i.e. profile has sub profile)

USR11

Text for authorisation profiles

USR12

Authorisation values

USR13

Short text for authorisation

USR40

Table for illegal passwords

OBJT

Authorisation object table

Regards,

Re: Which user has which authorizations

Former Member — Fri, 26 Dec 2008 09:57:43 GMT

Hi,

Check this thread.

Re: Which user has which authorizations

Former Member — Fri, 26 Dec 2008 10:02:21 GMT

hi,

check this table...here the roll of user are maintained :AGR_DEFINE( Role definition )

Arunima

Re: Which user has which authorizations

Former Member — Fri, 26 Dec 2008 10:10:59 GMT

Hi,

Check this .

USR01 contains the runtime data of the user master records

USR02 is the table containing logon information such as the password

USR03 includes the users' address information

USR04 contains users' authorizations

USR05 is the users' parameter ID table

USR09 contains user menus

USR10 is the table for user authorization profiles

USR11 contains the descriptive texts for profiles

USR12 is the user master authorization values table

USR13 contains the descriptive short texts for authorizations

USR14 contains the logon language versions per user

USR30 includes additional information for user menus

USH02, USH04, USH10 and USH12 contains Users and profile and

authorization change history data.

Tables related with authorizations objects and authorization fields are as follows:

TOBJ is the authorization objects table containing the authorization

fields for each.

TACT contains the list of standard activities authorization fields

in the system.

TACTZ is the table which defines the relationship between the

authorization objects and the activities in those objects containing

the Activity authorization field.

TSTC is the transaction code table where authorization objects

and values can be defined.