Instructions
This view has been introduced since version V4.0.0.
Purpose Description
Display the permissions owned by the current tenant to control the current user.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| USER_ID | NUMBER(38) | NO | The user ID. |
| USERNAME | VARCHAR2(128) | NO | The username. |
| DATABASE_NAME | VARCHAR2(128) | NO | The current database name associated with the 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 | Whether the privilege to modify tables exists. |
| PRIV_CREATE | VARCHAR2(3) | NO | Whether the privilege to create tables exists. |
| PRIV_DELETE | VARCHAR2(3) | NO | Whether the privilege to delete table records exists. |
| PRIV_DROP | VARCHAR2(3) | NO | Whether the privilege to drop tables exists. |
| PRIV_GRANT_OPTION | VARCHAR2(3) | NO | Whether the privilege to grant other privileges exists. |
| PRIV_INSERT | VARCHAR2(3) | NO | Whether the privilege to insert records exists. |
| PRIV_UPDATE | VARCHAR2(3) | NO | Whether the privilege to update records exists. |
| PRIV_SELECT | VARCHAR2(3) | NO | Whether the privilege to query records exists. |
| PRIV_INDEX | VARCHAR2(3) | NO | Whether the privilege to add indexes to tables exists. |
| PRIV_CREATE_VIEW | VARCHAR2(3) | NO | Whether the privilege to create views exists. |
| PRIV_SHOW_VIEW | VARCHAR2(3) | NO | Whether the privilege to view existing views exists. |
Sample query
A user tenant views the privileges within the current tenant that control the current user's access.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_DATABASE_PRIVILEGE;
The query result is as follows:
+---------+----------+---------------+------------------------------+------------------------------+------------+-------------+-------------+-----------+-------------------+-------------+-------------+-------------+------------+------------------+----------------+
| USER_ID | USERNAME | DATABASE_NAME | GMT_CREATE | GMT_MODIFIED | PRIV_ALTER | PRIV_CREATE | PRIV_DELETE | PRIV_DROP | PRIV_GRANT_OPTION | PRIV_INSERT | PRIV_UPDATE | PRIV_SELECT | PRIV_INDEX | PRIV_CREATE_VIEW | PRIV_SHOW_VIEW |
+---------+----------+---------------+------------------------------+------------------------------+------------+-------------+-------------+-----------+-------------------+-------------+-------------+-------------+------------+------------------+----------------+
| 200003 | SYS | LBACSYS | 05-FEB-25 05.47.08.718254 PM | 05-FEB-25 05.47.08.718254 PM | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES |
| 200003 | SYS | oceanbase | 05-FEB-25 05.47.08.712015 PM | 05-FEB-25 05.47.08.712015 PM | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES |
| 200003 | SYS | ORAAUDITOR | 05-FEB-25 05.47.08.719295 PM | 05-FEB-25 05.47.08.719295 PM | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES |
| 200003 | SYS | SYS | 05-FEB-25 05.47.08.717198 PM | 05-FEB-25 05.47.08.717198 PM | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES |
| 200003 | SYS | __public | 05-FEB-25 05.47.08.717198 PM | 05-FEB-25 05.47.08.717198 PM | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES |
| 200003 | SYS | __recyclebin | 05-FEB-25 05.47.08.716143 PM | 05-FEB-25 05.47.08.716143 PM | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES |
+---------+----------+---------------+------------------------------+------------------------------+------------+-------------+-------------+-----------+-------------------+-------------+-------------+-------------+------------+------------------+----------------+
6 rows in set