Which command will allow user Thompson to remove rows from the CUSTOMER table?
A) GRANT DROP ON CUSTOMER TO THOMPSON;
B) GRANT THOMPSON REMOVE ON CUSTOMER;
C) SELECT* CUSTOMER GRANT THOMPSON DELETE;
D) GRANT DELETE ON CUSTOMER TO THOMPSON;

Question

Quizplus · Accepted Answer

The correct SQL command to allow a user to remove rows from a table is "GRANT DELETE ON [table name] TO [user];" Therefore, the correct command to allow user Thompson to remove rows from the CUSTOMER table is "GRANT DELETE ON CUSTOMER TO THOMPSON;".

Which Command Will Allow User Thompson to Remove Rows from the CUSTOMER