USER_AUTH

Description


Technical Data


Schema Version 4.5.13
Tablespace CATALOG_DATA
Partitioned No

Summary


The USER_AUTH table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
OID PK_UA        USER_ROLE_AUTH (AUTH_OID)
 
ID     IX_UA_ID     
DESCRIPTION          
ACTIVITY_ID          

Column Details


OID

Definition The authorization unique ID
Description The authorization unique ID. It is generated by the SAP CC system.
Type DECIMAL(28), NOT NULL
Primary Key PK_UA

ID

Definition The identifier of the authorization
Type VARCHAR(256), NOT NULL
Available Index IX_UA_ID

DESCRIPTION

Definition The full description of the authorization
Type VARCHAR(2000), NULL

ACTIVITY_ID

Definition The identifier of the activity referred to by the authorization
Type VARCHAR(256), NOT NULL

Primary Key Details


PK_UA

Column(s) OID
Tablespace CATALOG_INDX

Index Details


The following database indexes are available in the USER_AUTH database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_UA_ID

Indexed Column(s) ID
Unique Yes
Partitioned No
Tablespace CATALOG_INDX