创建与DBA角色相同权限的角色
创建与DBA角色权限相同的角色，实际上就是将dba_sys_privs、dba_tab_privs、dba_role_privs三个视图的权限全部赋给新建的角色里；除
SQL> SELECT 'grant '||privilege||' to acct_role;' FROM dba_sys_privs WHERE grantee='DBA';
SQL> SELECT 'grant '||privilege||' on '||owner||'.'||table_name ||' to acct_role;' FROM dba_tab_privs WHERE grantee='DBA';
SQL> SELECT 'grant '||granted_role||' to acct_role;' FROM dba_role_privs WHERE grantee='DBA';
SQL>unlimited tablespace acct_role;
SQL> SELECT 'grant '||privilege||' to acct_role;' FROM dba_sys_privs WHERE grantee='DBA';
SQL> SELECT 'grant '||privilege||' on '||owner||'.'||table_name ||' to acct_role;' FROM dba_tab_privs WHERE grantee='DBA';
SQL> SELECT 'grant '||granted_role||' to acct_role;' FROM dba_role_privs WHERE grantee='DBA';
SQL>unlimited tablespace acct_role;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29446986/viewspace-2120193/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
