Multiple choice technology databases

Which of the following SQL statements allows user augustin to use the privileges associated with the password-protected role info_czar, which has been granted to him?

  1. set role all;

  2. alter user augustin default role all;

  3. alter session enable role info_czar;

  4. alter session enable info_czar identified by brozo
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ALTER USER DEFAULT ROLE ALL enables all granted roles (including password-protected ones) automatically at login without requiring SET ROLE. Option A is invalid syntax, C is not valid syntax, and D is obsolete.

Keep practicing — related questions