The ____ command will assign a default role to a user.
A) ALTER USER username MODIFY ROLE rolename;
B) ALTER DEFAULT ROLE rolename GRANT username;
C) ALTER ROLE rolename MODIFY USER username;
D) ALTER USER username DEFAULT ROLE rolename;

Question

The ____ command will assign a default role to a user.​
A) ​ALTER USER username MODIFY ROLE rolename;
B) ​ALTER DEFAULT ROLE rolename GRANT username;
C) ​ALTER ROLE rolename MODIFY USER username;
D) ​ALTER USER username DEFAULT ROLE rolename;

Quizplus · Accepted Answer

The correct command to assign a default role to a user is ALTER USER username DEFAULT ROLE rolename.

The ____ Command Will Assign a Default Role to a User.​

The ____ Command Will Assign a Default Role to a User.