查询sys用户直接赋予用户icdpub的权限:
select * from dba_sys_privs t where t.grantee='ICDPUB';
查询用户通过role赋权所得到的权限:
SELECT * FROM DBA_ROLE_PRIVS T WHERE T.grantee='ICDPUB';
收回用户的权限:
revoke create table from icdpub;
收回用户的角色:
revoke icdpub_role from icdpub;
查询sys用户直接赋予用户icdpub的权限:
select * from dba_sys_privs t where t.grantee='ICDPUB';
查询用户通过role赋权所得到的权限:
SELECT * FROM DBA_ROLE_PRIVS T WHERE T.grantee='ICDPUB';
收回用户的权限:
revoke create table from icdpub;
收回用户的角色:
revoke icdpub_role from icdpub;