To revoke unnecessary and unused privileges, you can use Privilege Analysis. Which sequence
should you follow?
1 -Start the analysis.
2 – Set up the analysis policy type (database, role, context).
3 – Generate the results.
4 -View the results in DBA_USED_PRIVSand DBA_UNUSED_PRJVS.
5 – Stop the analysis.
A.
1, 2, 3, 4, 5
B.
2, 1, 5, 3, 4
C.
5, 1, 2, 3, 4
D.
2, 3, I, 5, 4
E.
1, 2, 4, 5, 2
Correct answer is: B
https://docs.oracle.com/database/121/DVADM/priv_analysis.htm#DVADM1005
correct Answer is B
General Steps for Managing Privilege Analysis
1. Define/Create the privilege analysis policy
DBMS_PRIVILEGE_CAPTURE.CREATE_CAPTURE(…’logon_users_analysis_pol’…)
2. Enable the privilege analysis policy.
EXEC DBMS_PRIVILEGE_CAPTURE.ENABLE_CAPTURE(‘logon_users_analysis_pol’);
This step begins recording the privilege use that the policy defined.
3. Disable the privilege analysis policy’s recording of privilege use.
EXEC DBMS_PRIVILEGE_CAPTURE.DISABLE_CAPTURE(‘logon_users_analysis_pol’);
This step stops capturing the privilege use for the policy.
4. Generate privilege analysis results.
EXEC DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT(‘logon_users_analysis’);
This step writes the results to the data dictionary views –
DBA_PRIV_CAPTURES – Lists information about existing privilege analysis policies
DBA_USED_PRIVS – Lists the privileges that have been used for reported privilege analysis policies
DBA_UNUSED_PRIVS – Lists the privileges that have not been used for reported privilege analysis policies
5. Optionally, disable and then drop the privilege analysis policy.
EXEC DBMS_PRIVILEGE_CAPTURE.DROP_CAPTURE(‘logon_users_analysis_pol’);
Dropping a privilege analysis policy deletes the data captured by the policy.