Which of the following statements allows USER1 to take away read access on the table
ORG.TAB1 from USER2?
A.
REVOKE SELECT FROM user2 ON TABLE org.tab1
B.
REVOKE SELECT ON TABLE org.tab1 FROM user2
C.
REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
D.
REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
SELECT
Revokes the privilege to retrieve rows from the table or view, to create a view on a table, and to run the EXPORT utility against the table or view.
Revoking SELECT privilege may cause some views to be marked inoperative. (For information on inoperative views, see “CREATE VIEW”.)
0
0