SAP Security Tables of User master record

The following training tutorials guide briefly the most common SAP security tables of user master records that are used in SAP. In our previous training tutorials, we learned about how to create authorization objects and classes in SAP.

You can view SAP security tables of user master records in SAP by using transaction code “SE16”.

Table USR01: – It provides the run time date of the master record. This table provides the user details with the client, user name, start menu, spool request, print parameters, date format, time format, decimal notation, etc.

SAP Security Table USR01

Table USR02: – 

This table contains all the dates of the user master record. So this provides the details like user name in master record, user type, user group in master record, login failed attempts, user lock status, creator of a user account, last login date and time, etc.

SAP Security Tables of User master Record USR02

Table USR04

This table contains all the dates of user authorization and profile assignment. It provides the details like the client, user name in master record, last modification date and time and by whom it was changed, number of profiles, or authorization assigned to users.

SAP Security Table USR04

Table USR05: – This table contains the details of user parameters. It provides the details like the client, user name in master record, parameter id, and parameter value.

SAP Security Tables of User master Record USR05

Table USR10: – This table provides the details of the profile with authorizations. It provides the details like client id, authorization profile in user master maintenance, active or maintenance screen, last modification date, time and name, department name, type of profile i.e composite or single, and a number of profiles or authorization assigned to users.

SAP Security Tables of User master Record USR10

Table USR11: – It contains the details of the authorization profile text. This is able to provide the information of the client, authorization profile, active versions and texts in user master record.

Table USR12: –  It gives the information of authorization values. This table provides the details like authorization objects, maintenance version, modification date and time, type of profile, etc.