Q149 You want to apply the principle of Least Privilege in all your live databases

Q149 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 types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose two.)

• A) analysis of privileges that a user has on their own schema objects
• B) analysis of privileges that a user has on other schema’s objects
• C) analysis of privileges granted directly to a role that are then used by a user who has been granted that role
• D) analysis of all privileges used by SYS user.
• E) analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role