السلام عليكم
مثلاً يوزر يملك الصلاحية " sysdba "
هل يمكن معرفة التاريخ الذي تم فيه اعطاءه هذه الصلاحية ؟

بمراجعة محتويات اجداول التالي ذكرها يمكنك ايجاد معلومات وافية

Determine Roles and Privileges Granted to UsersThis is a featured page
set lines 110 pages 1000 ver off
col role for a16
col pv for a75 hea 'PRIVILEGE OR ROLE'
bre on role on type skip 1

define usercheck = 'SH'

select grantee, 'ROL' type, granted_role pv
from dba_role_privs where grantee = '&usercheck' union
select grantee, 'PRV' type, privilege pv
from dba_sys_privs where grantee = '&usercheck' union
select grantee, 'OBJ' type,
max(decode(privilege,'WRITE','WRITE,'))||max(decode(privilege,'READ','READ'))||
max(decode(privilege,'EXECUTE','EXECUTE'))||max(decode(privilege,'SELECT','SELECT'))||
max(decode(privilege,'DELETE',',DELETE'))||max(decode(privilege,'UPDATE',',UPDATE'))||
max(decode(privilege,'INSERT',',INSERT'))||' ON '||object_type||' "'||a.owner||'.'||table_name||'"' pv
from dba_tab_privs a, dba_objects b
where a.owner=b.owner and a.table_name = b.object_name and a.grantee='&usercheck'
group by a.owner,table_name,object_type,grantee union
select username grantee, '---' type, 'empty user ---' pv from dba_users
where not username in (select distinct grantee from dba_role_privs) and
not username in (select distinct grantee from dba_sys_privs) and
not username in (select distinct grantee from dba_tab_privs) and username like '%&usercheck%'
group by username
order by grantee, type, pv;

استخدم USER_SYS_PRIVS and USER_ROLE_PRIVS and role_sys_privs
كذلك

Select LPAD (' ', 2 * Level)
|| granted_role "user, his roles and privileges"
From ( /* the users */Select Null grantee, username granted_role
From dba_users
Where username Like
UPPER
('%&enter_username%')
/* the roles to roles relations */
Union
Select grantee, granted_role
From dba_role_privs
/* the roles to privilege relations */
Union
Select grantee, Privilege
From dba_sys_privs)
Start With grantee Is Null
Connect By grantee = Prior granted_role;

وببساطة لمعرفة Role Creation Date time stamp يمكنك

QL> select name,to_char(ctime,'dd/mm/yyyy hh24:mi:ss') ctime from user$

select owner,object_name,object_type from dba_objects where object_name='USER$';