oceanbase企业版支持oracle的权限管理以及用户角色等概念吗？支持以下形式的语句吗？
select * from session_privs;
select * from role_sys_privs;
社区版不兼容oracle模式吧
应该是社区版不兼容oracle，就是现在不知道企业版是否支持这种特性
select * from sys.role_sys_privs;
| ROLE | PRIVILEGE | ADMIN_OPTION |
|---|---|---|
| CONNECT | CREATE SESSION | NO |
| RESOURCE | CREATE TABLE | NO |
| RESOURCE | CREATE PROCEDURE | NO |
| RESOURCE | CREATE SEQUENCE | NO |
| RESOURCE | CREATE TRIGGER | NO |
| RESOURCE | CREATE TYPE | NO |
| DBA | CREATE SESSION | YES |
| DBA | CREATE TABLE | YES |
| DBA | CREATE ANY TABLE | YES |
| DBA | ALTER ANY TABLE | YES |
| DBA | BACKUP ANY TABLE | YES |
| DBA | DROP ANY TABLE | YES |
| DBA | LOCK ANY TABLE | YES |
| DBA | COMMENT ANY TABLE | YES |
| DBA | SELECT ANY TABLE | YES |
| DBA | INSERT ANY TABLE | YES |
| DBA | UPDATE ANY TABLE | YES |
| DBA | DELETE ANY TABLE | YES |
| DBA | FLASHBACK ANY TABLE | YES |
| DBA | CREATE ROLE | YES |
| DBA | DROP ANY ROLE | YES |
| DBA | GRANT ANY ROLE | YES |
| DBA | ALTER ANY ROLE | YES |
| DBA | AUDIT ANY | YES |
| DBA | GRANT ANY PRIVILEGE | YES |
| DBA | GRANT ANY OBJECT PRIVILEGE | YES |
| DBA | CREATE ANY INDEX | YES |
| DBA | ALTER ANY INDEX | YES |
| DBA | DROP ANY INDEX | YES |
| DBA | CREATE ANY VIEW | YES |
| DBA | DROP ANY VIEW | YES |
| DBA | CREATE VIEW | YES |
| DBA | SELECT ANY DICTIONARY | YES |
| DBA | CREATE PROCEDURE | YES |
| DBA | CREATE ANY PROCEDURE | YES |
| DBA | ALTER ANY PROCEDURE | YES |
| DBA | DROP ANY PROCEDURE | YES |
| DBA | EXECUTE ANY PROCEDURE | YES |
| DBA | CREATE SYNONYM | YES |
| DBA | CREATE ANY SYNONYM | YES |
| DBA | DROP ANY SYNONYM | YES |
| DBA | CREATE PUBLIC SYNONYM | YES |
| DBA | DROP PUBLIC SYNONYM | YES |
| DBA | CREATE SEQUENCE | YES |
| DBA | CREATE ANY SEQUENCE | YES |
| DBA | ALTER ANY SEQUENCE | YES |
| DBA | DROP ANY SEQUENCE | YES |
| DBA | SELECT ANY SEQUENCE | YES |
| DBA | CREATE TRIGGER | YES |
| DBA | CREATE ANY TRIGGER | YES |
| DBA | ALTER ANY TRIGGER | YES |
| DBA | DROP ANY TRIGGER | YES |
| DBA | CREATE PROFILE | YES |
| DBA | ALTER PROFILE | YES |
| DBA | DROP PROFILE | YES |
| DBA | CREATE USER | YES |
| DBA | BECOME USER | YES |
| DBA | ALTER USER | YES |
| DBA | DROP USER | YES |
| DBA | CREATE TYPE | YES |
| DBA | CREATE ANY TYPE | YES |
| DBA | ALTER ANY TYPE | YES |
| DBA | DROP ANY TYPE | YES |
| DBA | EXECUTE ANY TYPE | YES |
| DBA | UNDER ANY TYPE | YES |
| DBA | PURGE DBA_RECYCLEBIN | YES |
| DBA | CREATE ANY OUTLINE | YES |
| DBA | ALTER ANY OUTLINE | YES |
| DBA | DROP ANY OUTLINE | YES |
| DBA | SYSKM | YES |
| DBA | CREATE TABLESPACE | YES |
| DBA | ALTER TABLESPACE | YES |
| DBA | DROP TABLESPACE | YES |
| DBA | SHOW PROCESS | YES |
| DBA | ALTER SYSTEM | YES |
| DBA | CREATE DATABASE LINK | YES |
| DBA | CREATE PUBLIC DATABASE LINK | YES |
| DBA | DROP DATABASE LINK | YES |
| DBA | ALTER SESSION | YES |
| DBA | ALTER DATABASE | YES |
| DBA | CREATE ANY DIRECTORY | YES |
| DBA | DROP ANY DIRECTORY | YES |
| DBA | DEBUG CONNECT SESSION | YES |
| DBA | DEBUG ANY PROCEDURE | YES |
| DBA | CREATE ANY CONTEXT | YES |
| DBA | DROP ANY CONTEXT | YES |
session_privs 不支持。
1 个赞
企业版支持
好的
好的，谢谢