DB Wiki

User Tools

Site Tools

Trace:
privilegeanalysis

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
privilegeanalysis [2015/07/23 12:35] – z0hpvkprivilegeanalysis [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 7: Line 7:
     name      => 'rolecontext_policy',     name      => 'rolecontext_policy',
     type      => DBMS_PRIVILEGE_CAPTURE.g_role_and_context,     type      => DBMS_PRIVILEGE_CAPTURE.g_role_and_context,
-    roles     => role_name_list('DBA', 'EXP_FULL_DATABASE'+    roles     => role_name_list('DBA', 'EXP_FULL_DATABASE')
     condition => 'SYS_CONTEXT(''USERENV'', ''SESSION_USER'') = ''SYSTEM''');     condition => 'SYS_CONTEXT(''USERENV'', ''SESSION_USER'') = ''SYSTEM''');
 END;</code> END;</code>
Line 32: Line 32:
 <code>BEGIN <code>BEGIN
   DBMS_PRIVILEGE_CAPTURE.generate_result('rolecontext_policy');   DBMS_PRIVILEGE_CAPTURE.generate_result('rolecontext_policy');
-END;</code>                           +END;</code> 
 +The following views can now be used to see the results ... 
 +  * DBA_USED_SYSPRIVS 
 +  * DBA_USED_SYSPRIVS_PATH  
 +  * DBA_USED_OBJPRIVS 
 +  * DBA_USED_OBJPRIVS_PATH                      
privilegeanalysis.1437654935.txt.gz · Last modified: 2025/03/08 22:23 (external edit)