The ____ command is used to revoke a role.
A) REVOKE rolename FROM username;
B) ALTER rolename REVOKE username;
C) DROP rolename FROM username;
D) DROP rolename REVOKE FROM username;

Question

The ____ command is used to revoke a role.​
A) ​REVOKE rolename FROM username;
B) ​ALTER rolename REVOKE username;
C) ​DROP rolename FROM username;
D) ​DROP rolename REVOKE FROM username;

Quizplus · Accepted Answer

The REVOKE command is used to revoke a role from a user. The syntax for revoking a role is: REVOKE rolename FROM username. Option A is the only syntax that follows this format. Option B uses the ALTER command instead of REVOKE, option C uses the DROP command instead of REVOKE, and option D uses the syntax DROP rolename REVOKE instead of REVOKE rolename.

The ____ Command Is Used to Revoke a Role