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



Leave a Reply 1

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