基于湖库一体架构，统一管理结构化、半结构化与非结构化等多模态数据，一个系统承载事务处理、实时分析与 AI 工作负载。
DBA_OB_DATABASE_PRIVILEGE
更新时间：2026-07-16 19:52:04
编辑
分享
说明
该视图从 V4.0.0 版本开始引入。
功能描述
展示当前租户所拥有的控制当前用户的权限。
字段说明
| 字段名称 | 类型 | 是否可以为 NULL | 描述 |
|---|---|---|---|
| USER_ID | NUMBER(38) | NO | 用户 ID |
| USERNAME | VARCHAR2(128) | NO | 用户名称 |
| DATABASE_NAME | VARCHAR2(128) | NO | 当前用户名称 |
| GMT_CREATE | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | 创建时间 |
| GMT_MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | 修改时间 |
| PRIV_ALTER | VARCHAR2(3) | NO | 是否有修改表的权限 |
| PRIV_CREATE | VARCHAR2(3) | NO | 是否有创建表的权限 |
| PRIV_DELETE | VARCHAR2(3) | NO | 是否有删除表记录的权限 |
| PRIV_DROP | VARCHAR2(3) | NO | 是否有删除表的权限 |
| PRIV_GRANT_OPTION | VARCHAR2(3) | NO | 是否有转授权限 |
| PRIV_INSERT | VARCHAR2(3) | NO | 是否有插入记录的权限 |
| PRIV_UPDATE | VARCHAR2(3) | NO | 是否有更新记录的权限 |
| PRIV_SELECT | VARCHAR2(3) | NO | 是否有查询记录的权限 |
| PRIV_INDEX | VARCHAR2(3) | NO | 是否有给表加索引的权限 |
| PRIV_CREATE_VIEW | VARCHAR2(3) | NO | 是否有创建视图的权限 |
| PRIV_SHOW_VIEW | VARCHAR2(3) | NO | 是否有查看视图的权限 |
查询示例
用户租户查看本租户所拥有的控制当前用户的权限。
obclient [SYS]> SELECT * FROM SYS.DBA_OB_DATABASE_PRIVILEGE;
查询结果如下：
+---------+----------+---------------+------------------------------+------------------------------+------------+-------------+-------------+-----------+-------------------+-------------+-------------+-------------+------------+------------------+----------------+
| 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
