ROLES TRANSACTIONS Table
View exposing role assignment transaction records including action types, grant and view indicators, descend indicators, effective and expiration dates, and modifying user and date attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTION_TYPE |
Action type associated with the record. |
VARCHAR2 |
1 |
DESCEND |
Descend associated with the record. |
VARCHAR2 |
1 |
DO_FUNCTION |
Do function associated with the record. |
VARCHAR2 |
1 |
EFFECTIVE_DATE |
Date associated with effective. |
DATE |
|
EXPIRATION_DATE |
Date associated with expiration. |
DATE |
|
FUNCTION_CATEGORY_CODE |
Code identifying function category. |
VARCHAR2 |
4 |
GRANT_AND_VIEW |
Grant and view associated with the record. |
VARCHAR2 |
2 |
KRB_NAME |
Krb name associated with the record. |
VARCHAR2 |
8 |
MODIFIED_BY |
Modified by associated with the record. |
VARCHAR2 |
8 |
MODIFIED_DATE |
Date associated with modified. |
DATE |
|
ROLES_FUNCTION_KEY |
Surrogate key identifying the roles function. |
NUMBER |
|
ROLES_QUALIFIER_KEY |
Surrogate key identifying the roles qualifier. |
NUMBER |
12 |