PostgreSQL Exam PGCES-02 Topic 2 Question 41 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 41
Topic #: 2

[All PGCES-02 Questions]

I would like to enable all users to SELECT the "item" table. Select the most appropriate SQL statement from below.

AGRANT public SELECT ON item;

BGRANT SELECT ON item TO public;

CREVOKE 'r' ON item TO public;

DREVOKE READ ON item TO public;

EREVOKE public SELECT ON item;

Show Suggested Answer

Suggested Answer: A

by Eun at Mar 20, 2023, 08:40 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Gerald

3 days ago

E is just the opposite of what we want to do. We need to grant, not revoke, the SELECT privilege.

upvoted 0 times

...

Ramonita

9 days ago

Haha, 'C' and 'D' are clearly wrong. REVOKE 'r'? What is this, a pirate database?

upvoted 0 times

...

Otis

15 days ago

I was torn between options A and B, but B seems more precise in granting the SELECT privilege to the public.

upvoted 0 times

...

Winifred

16 days ago

I think option B is the correct answer. It grants the SELECT privilege to the public role on the 'item' table.

upvoted 0 times

...

Sena

18 days ago

I'm not sure, but I think option A) GRANT public SELECT ON item; could also be correct.

upvoted 0 times

...

Genevieve

19 days ago

I agree with Luis, because we want to grant the SELECT permission to the public group.

upvoted 0 times

...

Luis

21 days ago

I think the correct answer is B) GRANT SELECT ON item TO public.

upvoted 0 times

...