PostgreSQL_CE
PGCES-02 · Question #111
I would like to enable all users to SELECT the "item" table. Select the most appropriate SQL statement from below.
The correct answer is B. GRANT SELECT ON item TO public. See the full explanation below for the reasoning.
Question
I would like to enable all users to SELECT the "item" table. Select the most appropriate SQL statement from below.
Options
- 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;
How the community answered
(27 responses)- A4% (1)
- B70% (19)
- C4% (1)
- D15% (4)
- E7% (2)
Community Discussion
No community discussion yet for this question.