Oracle Exam 1Z0-082 Topic 13 Question 71 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 71
Topic #: 13

[All 1Z0-082 Questions]

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.)

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 that role

Fanalysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Show Suggested Answer

Suggested Answer: B, C

by Weldon at Feb 24, 2023, 10:44 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-082 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Reynalda

3 days ago

Definitely options A, D, and F. Gotta cover all the bases when it comes to privilege analysis! No more unnecessary permissions running amok in our database.

upvoted 0 times

...

Tom

21 days ago

That makes sense, we should prioritize analyzing privileges on schema objects to ensure Least Privilege is implemented properly.

upvoted 0 times

...

Trina

25 days ago

I disagree, I believe the correct analyses are B, D, and F. We need to focus on excluding administrative users and analyzing privileges on schema objects.

upvoted 0 times

...

Tom

28 days ago

I think the analyses that can be done using the DBMS_PRIVILEGE_CAPTURE package are A, C, and E.

upvoted 0 times

...