创建与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博客 ” ,链接:http://blog.itpub.net/29446986/viewspace-2120193/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29446986/viewspace-2120193/