1Z0-007 · Question #192
The user Sue issues this SQL statement: GRANT SELECT ON sue.EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue.EMP TO reena WITH GRANT OPTION; The user…
The correct answer is C. Alice, Reena, and Timber. use the REVOKE statement to revoke privileges granted to other users. Privilege granted to others through the WITH GRANT OPTION clause are also revoked. Alice, Reena and Timber will be revoke. Incorrect answer: A the correct answer should be Alice, Reena and Timber B the…
Question
The user Sue issues this SQL statement:
GRANT SELECT ON sue.EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:
GRANT SELECT ON sue.EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:
GRANT SELECT ON sue.EMP TO timber; The user Sue issues this SQL statement:
REVOKE select on sue.EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?
Options
- AAlice only
- BAlice and Reena
- CAlice, Reena, and Timber
- DSue, Alice, Reena, and Timber
How the community answered
(29 responses)- A17% (5)
- B3% (1)
- C72% (21)
- D7% (2)
Explanation
use the REVOKE statement to revoke privileges granted to other users. Privilege granted to others through the WITH GRANT OPTION clause are also revoked. Alice, Reena and Timber will be revoke. Incorrect answer: A the correct answer should be Alice, Reena and Timber B the correct answer should be Alice, Reena and Timber D the correct answer should be Alice, Reena and Timber
Topics
Community Discussion
No community discussion yet for this question.