Oracle
1Z0-060 · Question #162
In your Oracle 12c database, you create two roles: and AUDIT_ADMIN. You then AUDITOR execute the following commands: To create a privilege analysis policy for the AUDIT_ADMIN role, you execute the…
The correct answer is B. It only captures the use of the privileges used through the AUDIT_ADMIN role when the. https://docs.oracle.com/database/121/DVADM/priv_analysis.htm#DVADM591
New Features for Security
Question
In your Oracle 12c database, you create two roles: and AUDIT_ADMIN. You then AUDITOR execute the following commands: To create a privilege analysis policy for the AUDIT_ADMIN role, you execute the following PL/SQL block: Which statement is correct about the procedure?
Exhibit
Options
- AIt always captures the use of the CREATE VIEW and CREATE TABLE privileges.
- BIt only captures the use of the privileges used through the AUDIT_ADMIN role when the
- CIt always captures the use of the privileges exercised through the AUDITOR and AUDIT_ADMIN
- DIt captures the use of the privileges used through the AUDIT_ADMIN and AUDITOR roles when
How the community answered
(57 responses)- A12% (7)
- B58% (33)
- C25% (14)
- D5% (3)
Explanation
https://docs.oracle.com/database/121/DVADM/priv_analysis.htm#DVADM591
Topics
#privilege analysis#role-based capture#DBMS_PRIVILEGE_CAPTURE#audit policy
Community Discussion
No community discussion yet for this question.