Which of the following SQL statements rescinds privileges for user kchen05 to create constraints and delete data in the Customers table?
A)REVOKE ALL ON Customers TO kchen05;
B)REVOKE CONSTRAINTS, DELETE ON Customers TO kchen05;
C)REVOKE REFERENCES, DELETE ON Customers TO kchen05;
D)RESCIND REFERENCES, DELETE ON Customers TO kchen05;

Question

Quizplus · Accepted Answer

The correct SQL statement to rescind privileges for creating constraints (REFERENCES privilege) and deleting data (DELETE privilege) in the Customers table for user kchen05 is: `REVOKE REFERENCES, DELETE ON Customers TO kchen05;`. The REFERENCES privilege allows a user to create a foreign key constraint that references a table, and the DELETE privilege allows a user to delete rows from a table.

Which of the Following SQL Statements Rescinds Privileges for User