The USER_RIGHT table contains the authorization roles of each SAP CC user.
Each row is a role assigned to an SAP CC user.
Note that a user can have many roles.
| Schema Version | 2025.0.2 | |
| Partitioned | No | |
The USER_RIGHT table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| USER_OID | IX_USER | HCI_USER (OID)
|
|
The unique ID of the SAP CC user (individual user or service user) as defined in the HCI_USER table | ||
| USER_ASSIGNMENT_OID |
|
The unique ID of the user right assignment as defined in the USER_RIGHT_ASSIGNMENT table | ||||
| USER_RIGHT |
|
A role assigned to this SAP CC user |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The unique ID of the SAP CC user (individual user or service user) as defined in the HCI_USER table |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_USER |
| Definition | The unique ID of the user right assignment as defined in the USER_RIGHT_ASSIGNMENT table |
| Type | DECIMAL(28), NULL |
| Definition | A role assigned to this SAP CC user |
| Description |
A role assigned to this SAP CC user.
Note that the name of this column is wrong for compatibility reason.
|
| Format |
The main default roles are:
|
| Type | NVARCHAR(1000), NULL |
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:
| Indexed Column(s) | USER_OID |
| Unique | No |
| Partitioned | No |
