Question

Which of the following SQL statements rescinds privileges for user KCHEN05 to create constraints and delete data in the customers table?

a) `REVOKE ALL PRIVILEGES ON customers FROM kchen05;`
b) `DENY CREATE, DELETE ON customers TO kchen05;`
c) `DROP CONSTRAINT, DELETE FROM customers WHERE USER = 'kchen05';`
d) `REMOVE PRIVILEGES CREATE, DELETE FROM customers TO kchen05;`

Answer 1

The correct SQL statement to rescind privileges for user KCHEN05 is a) 'REVOKE ALL PRIVILEGES ON customers FROM kchen05;'. The REVOKE command is used to remove specific or all privileges from a user.

Step-by-step explanation:

The SQL statement that rescinds privileges for user KCHEN05 to create constraints and delete data in the customers table among the provided options is a) REVOKE ALL PRIVILEGES ON customers FROM kchen05;. SQL REVOKE command is used to remove privileges granted to a user. In the context of the question, specifically revoking the CREATE and DELETE privileges could be done with a more granular statement, but option a) effectively rescinds all privileges including those that allow creating constraints and deleting data.