Multiple choice technology databases

Which command can be used to disable all the roles including the default roles?

  1. Set Role Off

  2. Drop Role All

  3. .Revoke Role All

  4. Set Role None

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SET ROLE NONE is the SQL command that disables all roles for the current session, including default roles. SET ROLE OFF is not valid SQL syntax. DROP ROLE ALL would attempt to drop roles from the database, not disable them for a session. REVOKE ROLE ALL would revoke privileges, not disable roles.