Which of the following SQL statements will revoke the DBA role from user RTHOMAS?
A) REVOKE ROLE dba FROM rthomas;
B) UNGRANT ROLE dba FROM rthomas;
C) REVOKE dba FROM rthomas;
D) UNGRANT dba FROM rthomas;

Question

Which of the following SQL statements will revoke the DBA role from user RTHOMAS?​
A) ​REVOKE ROLE dba FROM rthomas;
B) ​UNGRANT ROLE dba FROM rthomas;
C) ​REVOKE dba FROM rthomas;
D) ​UNGRANT dba FROM rthomas;

Quizplus · Accepted Answer

The correct syntax to revoke a role from a user is "REVOKE role_name FROM user_name". Option A is close, but "ROLE" is not needed before the role name. Option B and D are not valid SQL syntax.

Which of the Following SQL Statements Will Revoke the DBA