oracle 查询用户权限

userinfo .sqluserinfo.sql

 

set serveroutput on
set echo off

declare
 
cursor user_cursor is select username,account_status,default_tablespace  from dba_users where username not in('SYS','SYSTEM') order by 2 desc,1;
 
begin
 
 for userval in user_cursor loop
  dbms_output.put_line('--------------------------------------');
  dbms_output.put_line('UserName:'||userval.username);
  dbms_output.put_line('  status:'||userval.account_status);
  dbms_output.put_line('  tbs:'||userval.default_tablespace);

    declare
      cursor cur_role is select GRANTED_ROLE from dba_role_privs where GRANTEE=userval.username;  
      cursor cur_privs is select PRIVILEGE from dba_sys_privs where GRANTEE=userval.username;
    begin
        for vrole in cur_role loop       
           dbms_output.put_line('--role:'||vrole.GRANTED_ROLE);
        end loop; 
      
        for vprivs in cur_privs loop       
           dbms_output.put_line('**privs:'||vprivs.PRIVILEGE);
        end loop; 
    end; 
 
 end loop;
END ;
/

  spool userInfo . log

@userinfo.sql

spool off

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22193071/viewspace-1122907/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22193071/viewspace-1122907/