Monday, 27 August 2012

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

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;

Ans:D

No comments: