Page 1 of 1

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

Posted: Wed Jun 07, 2023 6:12 am
by answerhappygod
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?

A. GRANT select ON dept TO ALL_USERS;
B. GRANT select ON dept TO ALL;
C. GRANT QUERY ON dept TO ALL_USERS
D. GRANT select ON dept TO PUBLIC;