Which of the following will revoke a user's object privileges?
A) REVOKE objectprivilege ON OBJECT objectname FROM username;
B) REVOKE objectprivilege ON objectname FROM username;
C) REVOKE objectprivilege ON objectname FOR username;
D) DROP objectprivilege ON objectname FROM username;

Question

Which of the following will revoke a user's object privileges?​
A) ​REVOKE objectprivilege ON OBJECT objectname FROM username;
B) ​REVOKE objectprivilege ON objectname FROM username;
C) ​REVOKE objectprivilege ON objectname FOR username;
D) ​DROP objectprivilege ON objectname FROM username;

Quizplus · Accepted Answer

The syntax for revoking object privileges is "REVOKE objectprivilege ON objectname FROM username." Option B follows this syntax correctly and is the best choice. Option A has an unnecessary "OBJECT" keyword, option C uses "FOR" instead of "FROM," and option D is not valid syntax for revoking object privileges.

Which of the Following Will Revoke a User's Object Privileges?​

Which of the Following Will Revoke a User's Object Privileges?