Which of the following statements is used to grant user TOM and
Application team APPGRP the ability to add data to table TAB1?
A.
GRANT ADD DATA ON TABLE tab1 TO GROUP tomappgrp
B.
GRANT INSERT TO USER tom, GROUPappgrp ON TABLE tab1
C.
GRANT INSERT ON TABLE tab1 TO USER tom, GROUPappgrp
D.
GRANT ADD DATA ON TABLE tab1 TO USERappgrp, GROUP tom
INSERT
Grants the privilege to insert rows into the table or updatable view and to run the IMPORT utility.
TO
Specifies to whom the privileges are granted.
USER
Specifies that the authorization-name identifies a user.
GROUP
Specifies that the authorization-name identifies a group name.
ON TABLE table-name or view-name or nickname
Specifies the table, view, or nickname on which privileges are to be granted.
No privileges may be granted on an inoperative view or an inoperative materialized query table (SQLSTATE 51024). No privileges may be granted on a declared temporary table (SQLSTATE 42995).
0
0