ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam
Go to Exam

Exam 1z0-082 topic 1 question 118 discussion

Actual exam question from Oracle's 1z0-082
Question #: 118
Topic #: 1
[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 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 Hide Answer
Suggested Answer: DE 🗳️
by ivanadj at Feb. 20, 2023, 2:35 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Oracle2020
3 months, 1 week ago
AD for me
upvoted 1 times
...
zouve
11 months ago
Selected Answer: DE
DE for me
upvoted 1 times
...
auwia
1 year 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
...
RaNik69
1 year, 1 month ago
Selected Answer: DE
D E are correct
upvoted 1 times
...
j_tw
1 year, 2 months ago
I think A also can be correct...
upvoted 1 times
...
ivanadj
1 year, 4 months ago
Selected Answer: DE
https://www.examtopics.com/discussions/oracle/view/24044-exam-1z0-082-topic-1-question-63-discussion/
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago