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

Contribute your Thoughts:

Submit Cancel

1 minutes ago

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

upvoted 0 times

...

6 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

...

7 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

...

9 days ago

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

upvoted 0 times

...

10 days ago

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

upvoted 0 times

...

12 days ago

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

upvoted 0 times

...