A view named V.VIEW1 is based on a table named T.TABLE1. A user with DBADM authority
issues the following statement:
GRANT INSERT ON v.view1 TO user1 WITH GRANT OPTION
Which of the following statements is USER1 authorized to execute?
A.
GRANT INSERT ON t.table1 TO user2
B.
GRANT CONTROL ON v.view1 TO user2
C.
GRANT ALL PRIVILEGES ON v.view1 TO user2
D.
GRANT INSERT ON v.view1 TO user2
WITH GRANT OPTION
Allows the specified authorization-names to GRANT the privileges to others.
If the specified privileges include CONTROL, the WITH GRANT OPTION applies to all the applicable privileges except for CONTROL (SQLSTATE 01516).
0
0