Assume PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1 but not remove them?

technology databases

  1. REVOKE DROP ON T1 FROM PUBLIC

  2. REVOKE UPDATE ON T1 FROM PUBLIC

  3. REVOKE DELETE ON T1 FROM PUBLIC

  4. REVOKE CONTROL ON T1 FROM PUBLIC

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to know the basics of database management and the concept of privileges.

Option A: REVOKE DROP ON T1 FROM PUBLIC - This option revokes the privilege to drop (delete) the entire table T1. It doesn't address the issue of adding rows. Therefore, this option is incorrect.

Option B: REVOKE UPDATE ON T1 FROM PUBLIC - This option revokes the privilege to update existing rows in the table T1. This means that the user cannot change the data in the rows that already exist in the table. It does not address the issue of adding rows. Therefore, this option is incorrect.

Option C: REVOKE DELETE ON T1 FROM PUBLIC - This option revokes the privilege to delete rows from the table T1. This means that the user cannot remove rows from the table. However, the user can still add rows to the table. Therefore, this option is correct.

Option D: REVOKE CONTROL ON T1 FROM PUBLIC - This option revokes all privileges from the PUBLIC on table T1, including the ability to add rows. Therefore, this option is incorrect.

The Answer is: C

Find more quizzes: