USER_RIGHT
Description
The USER_RIGHT table contains the authorization roles of each SAP CC user. Each row is a role assigned to an SAP CC user. Each value in the USER_RIGHT column matches a role in the USER_ROLE table. Note that a user can have many roles.
Technical Data
| Schema Version | 4.5.13 | |
| Tablespace | CATALOG_DATA | |
| Partitioned | No | |
Summary
The USER_RIGHT table is defined by the following columns. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by |
|---|---|---|---|---|---|
| USER_OID | IX_USER | HCI_USER (OID)
|
|||
| USER_RIGHT |
Column Details
USER_OID
| Definition | The unique ID of an SAP CC user (individual user or service user) as defined in the HCI_USER table |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_USER |
USER_RIGHT
| Definition | A role assigned to this SAP CC user |
| Description |
A role assigned to this SAP CC user. The roles are specified in the USER_ROLE table and can be customized by consultants or administrators. Note that the name of this column is wrong for compatibility reason. |
| Format |
The main default roles are:
|
| Type | VARCHAR2(1000 CHAR), NULL |
Index Details
The following database indexes are available in the USER_RIGHT database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
IX_USER
| Indexed Column(s) | USER_OID |
| Unique | No |
| Partitioned | No |
| Tablespace | CATALOG_INDX |