Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from
user TOM?
A.
REVOKE ALL PRIVILEGES FROM USER tom
B.
REVOKE ALL ON EMPLOYEE FROM USER tom
C.
REVOKE EXECUTE ON EMPLOYEE FROM USER tom
D.
REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
ALL or ALL PRIVILEGES
Revokes all privileges (except CONTROL) held by an authorization-name for the specified tables, views, or nicknames.
If ALL is not used, one or more of the keywords listed below must be used. Each keyword revokes the privilege described, but only as it applies to the tables, views, or nicknames named in the ON clause. The same keyword must not be specified more than once.
0
0