col BBDD format a15;
col Usuario format a20;
col account_status format a20;
col GRANTED_ROLE format a25;
set pagesize 999;
set linesize 200;
select p.value “BBDD”,
r.grantee “Usuario”,
r.ADMIN_OPTION,
r.GRANTED_ROLE,
u.account_status,
u.lock_date,
u.expiry_date,
u.created
from dba_role_privs r,
v$parameter p,
dba_users u
where p.name = ‘db_name’
and u.username = r.grantee
order by
r.grantee;
El resultado debe ser algo asi:
BBDD Usuario ADM GRANTED_ROLE ACCOUNT_STATUS LOCK_DAT EXPIRY_D CREATED
————— ——————– — ————————- ——————– ——– ——– ——–
apolo SCOTT NO RESOURCE EXPIRED & LOCKED 11/03/09 11/03/09 17/02/08
apolo SCOTT NO CONNECT EXPIRED & LOCKED 11/03/09 11/03/09 17/02/08
