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 ;
/
@userinfo.sql
spool off
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22193071/viewspace-1122907/ ，如需转载，请注明出处，否则将追究法律责任。
