You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which two are types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose two.)
The DBMS_PRIVILEGE_CAPTURE package can be used to perform analysis to capture and report on privilege usage. One type of analysis is the analysis of privileges that a user has on other schema’s objects to determine if unnecessary privileges can be revoked. Another type of analysis is the analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role to identify and manage privilege creep through roles. These are essential for implementing the principle of Least Privilege effectively, ensuring that users do not retain unnecessary permissions.
A. analysis of privileges that a user has on other schema’s objects. --> True, it makes sense. B. analysis of privileges that a user has on their own schema objects. --> False, it makes no sense. The owner is the owner why do you want to check his objects? :-) C. analysis of all privileges used by the sys user. --> False, SYS is the only user excluded by three tool. D. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role. --> True, it makes sense. E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role. --> False, it makes no sense.
AD for me
DE for me
D E are correct
I think A also can be correct...
https://www.examtopics.com/discussions/oracle/view/24044-exam-1z0-082-topic-1-question-63-discussion/