USER_XS_ACES
The USER_XS_ACES data dictionary view lists all the Access Control Entries (ACEs) from the ACLs owned by the current user.
Related Views
| Column | Datatype | NULL | Description |
|---|---|---|---|
ACL |
VARCHAR2(128) |
Name of the ACL | |
ACE_ORDER |
NUMBER |
NOT NULL |
Order number of the ACE in the ACL |
START_DATE |
TIMESTAMP(6) |
Effective start date of the ACE | |
END_DATE |
TIMESTAMP(6) |
Effective end date of the ACE | |
GRANT_TYPE |
VARCHAR2(5) |
Specifies whether the ACE is a GRANT or DENY |
|
INVERTED_PRINCIPAL |
VARCHAR2(3) |
YES if the principal is inverted, else NO |
|
PRINCIPAL |
VARCHAR2(128) |
Name of the principal to whom the ACE applies | |
PRINCIPAL_TYPE |
VARCHAR2(16) |
Type of the principal, such as application user or application role | |
PRIVILEGE |
VARCHAR2(128) |
Name of the application privilege | |
SECURITY_CLASS |
VARCHAR2(128) |
Name of the security class that scopes the ACL | |
SECURITY_CLASS_OWNER |
VARCHAR2(128) |
Owner of the security class that scopes the ACL |