Security tables
Table Description Reports
- USR02 Users Data (logon data) RSUSR020
- 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 RSUSR030
- USR13 Short text for authorisation
- USR40 Tabl for illegal passwords
- USGRP User groups
- USGRPT Text table for USGRP
- USH02 Change history for logon data
- USR01 User Master (runtime data)
- USER_ADDR Address Data for users
- AGR_1016 Role and Profile RSUSR020
- AGR_1016B Role and Profile
- AGR_1250 Role and Authorization data
- AGR_1251 Role Object, Authorization, Field and Value RSUSR040
- AGR_1252 Organizational elements for authorizations
- AGR_AGRS Roles in Composite Roles
- AGR_DEFINE To See All Roles (Role definition) RSUSR070
- AGR_HIER2 Menu structure information - Customer vers
- AGR_HIERT Role menu texts
- AGR_OBJ Assignment of Menu Nodes to Role
- AGR_PROF Profile name for role
- AGR_TCDTXT Assignment of roles to Tcodes
- AGR_TEXTS File Structure for Hierarchical Menu – Cus
- AGR_TIME Time Stamp for Role: Including profile
- AGR_USERS Assignment of roles to users
- USOBT Relation transaction to authorization object (SAP)
- USOBT_C Relation Transaction to Auth. Object (Customer)
- USOBX Check table for table USOBT
- USOBXFLAGS Temporary table for storing USOBX/T* chang
- USOBX_C Check Table for Table USOBT_C
- TSTCA Transaction Code, Object, Field and Value
More User/Security tables
- DEVACCESS Table of development users including dev access key
- 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 Tabl for illegal passwords
- OBJT Authorisation objetc table
Good post. Thanks a lot for listing all the security tables. I wanted to know if there is a way or query to list all the security tables. And what to do if we want to make some changes in one of these tables, is that really possible ?
ResponderBorrarsap support pack implementation