Which of the following SQL statements will remove the SELECT ANY TABLE privilege from the database so it can never be granted to another user?
A) REVOKE SELECT ANY TABLE;
B) REVOKE SELECT ANY TABLE FROM data_dictionary;
C) REMOVE SELECT ANY TABLE;
D) none of the above

Question

Which of the following SQL statements will remove the SELECT ANY TABLE privilege from the database so it can never be granted to another user?​
A) ​REVOKE SELECT ANY TABLE;
B) ​REVOKE SELECT ANY TABLE FROM data_dictionary;
C) ​REMOVE SELECT ANY TABLE;
D) ​none of the above

Quizplus · Accepted Answer

The SQL syntax provided in options A, B, and C does not correctly represent a way to permanently remove a privilege so it can never be granted again. The correct approach to permanently remove a privilege would involve altering system-level permissions or roles, not just a simple REVOKE or REMOVE command.

Which of the Following SQL Statements Will Remove the SELECT