Multiple choice technology databases

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?

  1. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO user1 AND group1

  2. GRANT INSERT, UPDATE, DELETE, SELECT ON TABLE table1 TO USER user1, GROUP group1

  3. GRANT ALL PRIVILEGES EXCEPT ALTER, INDEX, REFERENCES ON TABLE table1 TO USER user1, GROUP group1

  4. GRANT CONTROL ON TABLE table1 TO user1 AND group1
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DML operations include INSERT, UPDATE, DELETE, and SELECT. Option B grants exactly these four privileges to both USER1 and GROUP1. Option A incorrectly uses 'AND' instead of proper syntax. Option C would grant more than DML (it includes INDEX and REFERENCES implicitly). Option D's CONTROL privilege is too broad - it includes DDL rights.

Keep practicing — related questions