Which of the following will add a password to a role?
A) ALTER USER username SET ROLE rolename;
B) ALTER ROLE rolename SET USER username
C) ALTER USER username PASSWORD password;
D) ALTER ROLE rolename IDENTIFIED BY password;

Question

Quizplus · Accepted Answer

The correct statement to add a password to a role is ALTER ROLE rolename IDENTIFIED BY password.  The other statements do not involve setting a password for a role.

Which of the Following Will Add a Password to a Role