{9 権限分析}権限分析レポートを生成

 

https://docs.oracle.com/cd/F19136_01/dbseg/performing-privilege-analysis-identify-privilege-use.html#GUID-09B5E21E-5C5B-4171-B6D7-32DDF7EA1222

sqlplus test/test@pdb11

select * from DBA_PRIV_CAPTURES;

EXEC DBMS_PRIVILEGE_CAPTURE.DISABLE_CAPTURE ('db_wide_capture_pol');
EXEC DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT ('db_wide_capture_pol');

select count(*) from DBA_USED_PRIVS;
select count(*) from DBA_UNUSED_PRIVS;

select * from DBA_USED_PRIVS where capture = 'db_wide_capture_pol';