Exam 1z0-082 topic 1 question 118 discussion

Actual exam question from Oracle's 1z0-082

Question #: 118
Topic #: 1

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

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

Show Suggested Answer

Suggested Answer: DE 🗳️

by ivanadj at Feb. 20, 2023, 2:35 p.m.

Comments

Submit Cancel

Oracle2020

8 months, 3 weeks ago

AD for me

upvoted 1 times

...

zouve

1 year, 4 months ago

Selected Answer: DE

DE for me

upvoted 1 times

...

auwia

1 year, 5 months ago

Selected Answer: AD

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.

upvoted 2 times

...