Multiple choice technology databases

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?

  1. GRANT select ON dept TO ALL_USERS;

  2. GRANT select ON dept TO ALL;

  3. GRANT QUERY ON dept TO ALL_USERS;

  4. GRANT select ON dept TO PUBLIC;
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In SQL, the PUBLIC keyword represents a special user group containing all database users. Granting privileges to PUBLIC allows everyone to access the table, while other terms like ALL_USERS or ALL are syntactically incorrect here.

Keep practicing — related questions