如何给一个用户降权

查看此用户的所有系统权限：

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;