Feature
DBA_OB_DATABASE_PRIVILEGE lists tenant-level privileges of the current user.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| USER_ID | NUMBER(38) | NO | The ID of the user. |
| USERNAME | VARCHAR2(128) | NO | The username. |
| DATABASE_NAME | VARCHAR2(128) | NO | The name of the current user. |
| GMT_CREATE | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The creation time. |
| GMT_MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The modification time. |
| PRIV_ALTER | VARCHAR2(3) | NO | The user privilege to modify tables. |
| PRIV_CREATE | VARCHAR2(3) | NO | The user privilege to create tables. |
| PRIV_DELETE | VARCHAR2(3) | NO | The user privilege to drop table records. |
| PRIV_DROP | VARCHAR2(3) | NO | The user privilege to drop tables. |
| PRIV_GRANT_OPTION | VARCHAR2(3) | NO | The privileges granted to the current user. |
| PRIV_INSERT | VARCHAR2(3) | NO | The privilege to insert records. |
| PRIV_UPDATE | VARCHAR2(3) | NO | The privilege to update records. |
| PRIV_SELECT | VARCHAR2(3) | NO | The privilege to query records. |
| PRIV_INDEX | VARCHAR2(3) | NO | The privilege to set indexes. |
| PRIV_CREATE_VIEW | VARCHAR2(3) | NO | The privilege to create views. |
| PRIV_SHOW_VIEW | VARCHAR2(3) | NO | The privilege to check views. |