nerdexam
Oracle

1Z0-082 · Question #11

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…

The correct answer is A. analysis of all privileges used by all users including administrative users in the database C. analysis of privileges that a user has on their own schema objects that they did not use F. analysis of privileges granted indirectly to a role that are then used by a user who has been. https://docs.oracle.com/database/121/ARPLS/d_priv_prof.htm#ARPLS74328

New Features for Security

Question

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

Options

  • Aanalysis of all privileges used by all users including administrative users in the database
  • Banalysis of all privileges used by all users but excluding administrative users in the database
  • Canalysis of privileges that a user has on their own schema objects that they did not use
  • Danalysis of privileges that a user has on their own schema objects that they did use
  • Eanalysis of privileges granted directly to a role that are then used by a user who has been granted
  • Fanalysis of privileges granted indirectly to a role that are then used by a user who has been

How the community answered

(31 responses)
  • A
    81% (25)
  • B
    13% (4)
  • D
    3% (1)
  • E
    3% (1)

Explanation

https://docs.oracle.com/database/121/ARPLS/d_priv_prof.htm#ARPLS74328

Topics

#privilege analysis#DBMS_PRIVILEGE_CAPTURE#least privilege#role-based privileges

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice