🎴 Flashcard Mode
DB2 Database Administration and Privileges
Card1 / 20
Mastered0
Review0
QuestionClick to flip
USER1 is the owner of TABLE1. Assuming USER1 only holds privileges for TABLE1, which of the following is the best way to remove all privileges USER1 holds?
AnswerClick to flip back
A
REVOKE CONTROL ON table1 FROM user1; REVOKE ALL PRIVILEGES ON table1 FROM user1
💡 Explanation:
As the table owner, USER1 holds both CONTROL privilege (ownership-level authority) AND ALL PRIVILEGES (individual rights like SELECT, INSERT, etc.). Removing only CONTROL or only ALL PRIVILEGES would leave some privileges intact. Option C correctly revokes both - CONTROL removes ownership-level rights, and ALL PRIVILEGES removes any granted individual privileges.