注册
DBA角色无法转授权的权限
技术分享/ 文章详情 /

DBA角色无法转授权的权限

mbj 2026/05/14 95 0 0

数据库版本:win 8.1.4.170
–GRANT CREATE ANY SCHEMA TO MBJR;
–GRANT DROP ANY SCHEMA TO MBJR;
–GRANT CREATE ANY TABLE TO MBJR;
–GRANT ALTER ANY TABLE TO MBJR;
–GRANT DROP ANY TABLE TO MBJR;
–GRANT CREATE ANY VIEW TO MBJR;
–GRANT ALTER ANY VIEW TO MBJR;
–GRANT DROP ANY VIEW TO MBJR;
–GRANT CREATE ANY PROCEDURE TO MBJR;
–GRANT DROP ANY PROCEDURE TO MBJR;
–GRANT CREATE ANY SEQUENCE TO MBJR;
–GRANT DROP ANY SEQUENCE TO MBJR;
–GRANT CREATE ANY TRIGGER TO MBJR;
–GRANT DROP ANY TRIGGER TO MBJR;
–GRANT CREATE ANY INDEX TO MBJR;
–GRANT ALTER ANY INDEX TO MBJR;
–GRANT DROP ANY INDEX TO MBJR;
–GRANT CREATE ANY CONTEXT INDEX TO MBJR;
–GRANT ALTER ANY CONTEXT INDEX TO MBJR;
–GRANT DROP ANY CONTEXT INDEX TO MBJR;
–GRANT CREATE ANY PACKAGE TO MBJR;
–GRANT DROP ANY PACKAGE TO MBJR;
–GRANT CREATE ANY LINK TO MBJR;
–GRANT DROP ANY LINK TO MBJR;
–GRANT CREATE ANY SYNONYM TO MBJR;
–GRANT DROP ANY SYNONYM TO MBJR;
–GRANT ALTER ANY TRIGGER TO MBJR;
–GRANT CREATE ANY MATERIALIZED VIEW TO MBJR;
–GRANT DROP ANY MATERIALIZED VIEW TO MBJR;
–GRANT ALTER ANY MATERIALIZED VIEW TO MBJR;
–GRANT CREATE ANY DOMAIN TO MBJR;
–GRANT DROP ANY DOMAIN TO MBJR;
–GRANT CREATE ANY PARTITION GROUP TO MBJR;
–GRANT DROP ANY PARTITION GROUP TO MBJR;
–GRANT CREATE ANY OPERATOR TO MBJR;
–GRANT DROP ANY OPERATOR TO MBJR;
–GRANT CREATE ANY CONTEXT TO MBJR WITH ADMIN OPTION;
–GRANT DROP ANY CONTEXT TO MBJR WITH ADMIN OPTION;
–GRANT CREATE ANY DIRECTORY TO MBJR WITH ADMIN OPTION;
–GRANT DROP ANY DIRECTORY TO MBJR WITH ADMIN OPTION;
–GRANT ALTER ANY SEQUENCE TO MBJR WITH ADMIN OPTION;
–GRANT SELECT ON “SYS”.“PROXY_INFO$” TO MBJR WITH GRANT OPTION;

评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服