基于湖库一体架构，统一管理结构化、半结构化与非结构化等多模态数据，一个系统承载事务处理、实时分析与 AI 工作负载。
oceanbase.DBA_OB_DATABASE_PRIVILEGE
更新时间：2026-07-13 22:33:20
编辑
分享
说明
该视图从 V4.0.0 版本开始引入。
功能描述
展示当前租户下用户所拥有的数据库权限。
字段说明
| 字段名称 | 字段类型 | 是否可以为 NULL | 描述 |
|---|---|---|---|
| USER_ID | bigint(20) | NO | 用户 ID |
| USERNAME | varchar(128) | NO | 用户名称 |
| DATABASE_NAME | varchar(128) | NO | 数据库名称 |
| GMT_CREATE | timestamp(6) | NO | 创建时间 |
| GMT_MODIFIED | timestamp(6) | NO | 修改时间 |
| PRIV_ALTER | varchar(3) | NO | 是否有修改数据库或表的权限 |
| PRIV_CREATE | varchar(3) | NO | 是否有创建数据库或表的权限 |
| PRIV_DELETE | varchar(3) | NO | 是否有删除数据库或表记录的权限 |
| PRIV_DROP | varchar(3) | NO | 是否有删除数据库或表的权限 |
| PRIV_GRANT_OPTION | varchar(3) | NO | 是否有转授权限 |
| PRIV_INSERT | varchar(3) | NO | 是否有插入记录的权限 |
| PRIV_UPDATE | varchar(3) | NO | 是否有更新记录的权限 |
| PRIV_SELECT | varchar(3) | NO | 是否有查询记录的权限 |
| PRIV_INDEX | varchar(3) | NO | 是否有创建和删除索引的权限 |
| PRIV_CREATE_VIEW | varchar(3) | NO | 是否有创建视图的权限 |
| PRIV_SHOW_VIEW | varchar(3) | NO | 是否有查看视图的权限 |
| PRIV_EXECUTE | varchar(3) | NO | 是否有执行 Procedure 和 Function 的权限 |
| PRIV_ALTER_ROUTINE | varchar(3) | NO | 是否有修改或删除 Procedure 和 Function 的权限 |
| PRIV_CREATE_ROUTINE | varchar(3) | NO | 是否有创建 Procedure 和 Function 的权限 |
| PRIV_REFERENCES | varchar(3) | NO | 是否有创建外键的权限 |
| PRIV_TRIGGER | varchar(3) | NO | 是否有激活触发器操作的权限 |
| PRIV_LOCK_TABLE | varchar(3) | NO | 是否有对表加锁的权限 |
| PRIV_EVENT | varchar(3) | NO | 是否有创建和管理事件的权限 |
查询示例
系统租户查看本租户的用户所拥有的数据库权限。
obclient [oceanbase]> SELECT * FROM oceanbase.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 | PRIV_EXECUTE | PRIV_ALTER_ROUTINE | PRIV_CREATE_ROUTINE | PRIV_REFERENCES | PRIV_TRIGGER | PRIV_LOCK_TABLE | PRIV_EVENT |
+---------+----------+--------------------+----------------------------+----------------------------+------------+-------------+-------------+-----------+-------------------+-------------+-------------+-------------+------------+------------------+----------------+--------------+--------------------+---------------------+-----------------+--------------+-----------------+------------+
| 200001 | root | information_schema | 2025-02-05 17:44:33.687908 | 2025-02-05 17:44:33.687908 | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
| 200001 | root | LBACSYS | 2025-02-05 17:44:33.690017 | 2025-02-05 17:44:33.690017 | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
| 200001 | root | mysql | 2025-02-05 17:44:33.687908 | 2025-02-05 17:44:33.687908 | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
| 200001 | root | oceanbase | 2025-02-05 17:44:33.684624 | 2025-02-05 17:44:33.684624 | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
| 200001 | root | ORAAUDITOR | 2025-02-05 17:44:33.693182 | 2025-02-05 17:44:33.693182 | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
| 200001 | root | SYS | 2025-02-05 17:44:33.690017 | 2025-02-05 17:44:33.690017 | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
| 200001 | root | test | 2025-02-05 17:44:33.688963 | 2025-02-05 17:44:33.688963 | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
| 200001 | root | __public | 2025-02-05 17:44:33.686853 | 2025-02-05 17:44:33.686853 | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
| 200001 | root | __recyclebin | 2025-02-05 17:44:33.685798 | 2025-02-05 17:44:33.685798 | YES | YES | YES | YES | NO | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES | YES |
+---------+----------+--------------------+----------------------------+----------------------------+------------+-------------+-------------+-----------+-------------------+-------------+-------------+-------------+------------+------------------+----------------+--------------+--------------------+---------------------+-----------------+--------------+-----------------+------------+
9 rows in set
