Which of the following will provide user USER1 and all members of the group GROUP1 with the
ability to perform DML, but no other operations on table TABLE1?
A.
GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO user1 AND group1
B.
GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP
group1
C.
GRANT ALL PRIVILEGES EXCEPT ALTER, INDEX, REFERENCES ON TABLE table1 TO
USER user1, GROUP group1
D.
GRANT CONTROL ON TABLE table1 TO user1 AND group1
No EXCEPT in
GRANT (table, view, or nickname privileges) statement
This form of the GRANT statement grants privileges on a table, view, or nickname.
0
0