Oracle 1Z0-071 Exam - Topic 11 Question 127 Discussion

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

Question #: 127
Topic #: 11

[All 1Z0-071 Questions]

Which two are true about the WITH GRANT OPTION clause?

AThe grantee can grant the object privilege to any user in the database, with of without including this option.

BThe grantee must have the GRANT ANY OBJECT PRIVILEGE system prvilege to use this option.

CIt can be used when granting privileges to roles.

DIt can be used for system and object privileges.

EIt cannot be used to pass on privileges to PUBLIC by the grantee.

FIt can be used to pass on privileges to other users by the grantee.

Show Suggested Answer

Suggested Answer: E, F

The WITH GRANT OPTION clause in Oracle SQL allows the grantee to grant the privilege they have received to another user or role.

E . It cannot be used to pass on privileges to PUBLIC by the grantee: The WITH GRANT OPTION does not allow the grantee to pass on privileges to PUBLIC. Only the object's owner or a user with the GRANT ANY OBJECT PRIVILEGE system privilege can grant privileges to PUBLIC.

F . It can be used to pass on privileges to other users by the grantee: This is true. When a user receives privileges with the WITH GRANT OPTION, they can grant that privilege to another user or role.

Oracle Database SQL Language Reference 12c, specifically sections on user privileges and the WITH GRANT OPTION.

by Rachael at Mar 04, 2026, 11:52 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Timothy

4 hours ago

I remember something about option E being true since it seems logical that you can't grant privileges to PUBLIC with this option.

upvoted 0 times

...

Geoffrey

5 days ago

I'm not entirely sure about option B; I feel like the GRANT ANY OBJECT PRIVILEGE might not be necessary for using WITH GRANT OPTION.

upvoted 0 times

...

Donte

10 days ago

I think option F sounds correct because the WITH GRANT OPTION lets the grantee pass on privileges to others, right?

upvoted 0 times

...