查看指定用户获得的权限

create or replace procedure user_priv
(uname in varchar2)
as
 cursor v_cur is
        select privilege from dba_sys_privs where grantee=uname
 union
 select privilege from dba_sys_privs where grantee in
 (select granted_role from dba_role_privs where grantee=uname );

 begin
     for v_t in v_cur loop
 begin
     dbms_output.put_line(v_t.privilege);
 end;
    end loop;
 end;
/