Oralce用户权限管理

--查看用户有哪些角色
select granted_role from dba_role_privs where grantee='SCOTT';
--查看用户(角色)有哪些权限
select privilege from dba_sys_privs where grantee='SCOTT';
select privilege from dba_sys_privs where grantee='CONNECT';