which users does the revoke command revoke SELECT privileges on the SUE.EMP table?

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?

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?

A.
Alice only

B.
Alice and Reena

C.
Alice, Reena, and Timber

D.
Sue, Alice, Reena, and Timber

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:
Athe correct answer should be Alice, Reena and Timber
Bthe correct answer should be Alice, Reena and Timber

Dthe correct answer should be Alice, Reena and Timber
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-17



Leave a Reply 1

Your email address will not be published. Required fields are marked *


us

us

Have you ever considered publishing an e-book or guest authoring on other websites? I have a blog based on the same ideas you discuss and would love to have you share some stories/information. I know my subscribers would enjoy your work. If you are even remotely interested, feel free to send me an e mail.|