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

2 hours ago

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

upvoted 0 times

...