如何给一个用户降权
时间：2010-05-31 来源：dbconf
查看此用户的所有系统权限：
select * from dba_sys_privs where grantee='BACKUSER';
GRANTEE PRIVILEGE ADM ------------------------------ ---------------------------------------- BACKUSER CREATE SESSION NO
回收：revoke create session from backuser;
查看此用户的所有角色： select granted_role from dba_role_privs where grantee='BACKUSER';
GRANTED_ROLE ------------------------------ EXP_FULL_DATABASE DBA CONNECT
回收：revoke exp_full_database,connect,dba from backuser;
查询此用户的所有对象权限： select table_name,privilege from dba_tab_privs where grantee='BACKUSER';
TABLE_NAME PRIVILEGE ------------------------------ ---------------------------------------- EMP SELECT
回收：revoke select on scott.emp from backuser;
GRANTEE PRIVILEGE ADM ------------------------------ ---------------------------------------- BACKUSER CREATE SESSION NO
回收：revoke create session from backuser;
查看此用户的所有角色： select granted_role from dba_role_privs where grantee='BACKUSER';
GRANTED_ROLE ------------------------------ EXP_FULL_DATABASE DBA CONNECT
回收：revoke exp_full_database,connect,dba from backuser;
查询此用户的所有对象权限： select table_name,privilege from dba_tab_privs where grantee='BACKUSER';
TABLE_NAME PRIVILEGE ------------------------------ ---------------------------------------- EMP SELECT
回收：revoke select on scott.emp from backuser;
相关阅读 更多 +
