Multiple choice technology databases

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?

  1. GRANT INSERT ON t.table1 TO user2

  2. GRANT CONTROL ON v.view1 TO user2

  3. GRANT ALL PRIVILEGES ON v.view1 TO user2

  4. GRANT INSERT ON v.view1 TO user2
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

WITH GRANT OPTION allows the grantee (USER1) to grant the same privilege to others. USER1 received INSERT on V.VIEW1 with GRANT OPTION, so USER1 can grant INSERT on V.VIEW1 to USER2. USER1 cannot grant privileges on the underlying table (T.TABLE1), cannot grant CONTROL (different privilege), and cannot grant ALL PRIVILEGES (never received it).

Keep practicing — related questions