Oracle 1Z0-071 Exam - Topic 5 Question 123 Discussion

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

Question #: 123
Topic #: 5

Which two are true about granting privilege on objects?

AAn object privilege can be granted to a role only by the owner of that object

BAn object privilege can be granted to other users only by the owner of that object

CThe owner of an object acquires all object privilege on that object by default

DA table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table

EThe WITH GRANT OPTION clause can be used only by DBA users

Show Suggested Answer

Suggested Answer: C, D

C . True, the owner of an object automatically has all object privileges for that object by default. This is an inherent property of the object owner in Oracle. D . True, to allow the creation of foreign key constraints that reference a particular table, the owner of the table must grant the REFERENCES privilege on the key columns to other users or roles.

A, B, and E are not correct because: A. Object privileges can be granted to a role by any user with the appropriate permissions, not only by the owner. B. Object privileges can also be granted by users who have been given the privileges with the WITH GRANT OPTION, not just by the owner. E. The WITH GRANT OPTION is not limited to DBA users; it can be used by any user who has the privilege to grant a specific object privilege.

Oracle documentation on object privileges: Oracle Database SQL Language Reference

Oracle documentation on the REFERENCES privilege: Oracle Database Security Guide

by Martina at Nov 23, 2025, 04:50 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Alison

5 hours ago

I’m not so sure about B. I thought anyone could use WITH GRANT OPTION.

upvoted 0 times

...

Dorothea

5 days ago

I think A is definitely true. Owners have all privileges.

upvoted 0 times

...

Fatima

10 days ago

Wait, E? I’m surprised, I thought others could grant too!

upvoted 0 times

...

Graciela

29 days ago

C is correct, you need to grant references for foreign keys.

upvoted 0 times

...

Willie

1 month ago

I disagree with B, I thought anyone could use WITH GRANT OPTION.

upvoted 0 times

...

Chantell

1 month ago

Wait, so the table owner has to grant REFERENCES privilege, but can they still create FOREIGN KEY constraints on their own table? Seems like a lot of red tape.

upvoted 0 times

...

Lennie

1 month ago

Hmm, this exam question is as clear as mud. Where's the multiple choice option for "All of the above, except B"?

upvoted 0 times

...

Ling

2 months ago

B is incorrect. The WITH GRANT OPTION clause can be used by any user with the privilege to grant that object privilege, not just DBA users.

upvoted 0 times

...

Merissa

2 months ago

D is incorrect. Object privileges can be granted to roles by any user with the privilege to grant that object privilege.

upvoted 0 times

...

Linsey

2 months ago

I’m leaning towards D being true, but I’m a bit confused about E; can the owner really only grant privileges to other users?

upvoted 0 times

...

Celestine

2 months ago

I'm not so sure about B; I feel like I've seen examples where non-DBA users could use the WITH GRANT OPTION.

upvoted 0 times

...

Simona

2 months ago

I think A is definitely true because the owner usually has all privileges by default, right?

upvoted 0 times

...

Lauran

3 months ago

This is a good test of my understanding of object privileges. I'm going to carefully read through each option and think about what I know for certain, and where I might need to do some quick reviewing before answering.

upvoted 0 times

...

Alberto

3 months ago

I feel pretty good about this one. I remember learning that the object owner can grant privileges to other users, and that the REFERENCES privilege is needed for foreign key constraints. I'll make sure to double-check the other options though.

upvoted 0 times

...

Matthew

3 months ago

Okay, let me think this through. I know the owner gets all privileges by default, and that privileges can be granted to roles. But the details around the WITH GRANT OPTION and REFERENCES privilege are a bit fuzzy for me.

upvoted 0 times

...

Bethanie

3 months ago

C is also correct. The table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table.

upvoted 0 times

...

Mertie

3 months ago

A is true, the owner gets all privileges by default.

upvoted 0 times

...

Breana

3 months ago

A and E are correct. The owner of an object has all privileges on that object by default, and object privileges can only be granted by the owner.

upvoted 0 times

...

Emile

4 months ago

I remember practicing a question similar to C, and I think it’s true that the references privilege is needed for FOREIGN KEY constraints.

upvoted 0 times

...

Virgie

4 months ago

D sounds right, only the owner can grant privileges to roles.

upvoted 0 times

...

Lindy

4 months ago

Hmm, this looks tricky. I think I'll need to review my notes on object privileges and how they can be granted. Gotta make sure I understand the nuances here.

upvoted 0 times

...

Marquetta

4 months ago

I'm not too sure about this one. The question seems to cover a lot of different privilege concepts, and I'm not confident I have a solid grasp on all of them.

upvoted 0 times

...