Oracle
1Z0-007 · Question #96
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?
The correct answer is D. GRANT select ON dept. Explanation: view the columns associated with the constraint names in the USER_CONS_COLUMNS view. Incorrect answer: A table to view all constraints definition and names B show all object name belong to user C does not display column associated
Controlling User Access
Question
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?
Options
- AGRANT select ON dept
- BGRANT select ON dept
- CGRANT QUERY ON dept
- DGRANT select ON dept
How the community answered
(44 responses)- A7% (3)
- B18% (8)
- C5% (2)
- D70% (31)
Explanation
Explanation: view the columns associated with the constraint names in the USER_CONS_COLUMNS view. Incorrect answer: A table to view all constraints definition and names B show all object name belong to user C does not display column associated
Topics
#GRANT#PUBLIC#SELECT privilege#DCL
Community Discussion
No community discussion yet for this question.