Name of a role (which may include nested roles) to assign as the default role for the user. The role must already be granted to the user.
The assignment of a default role provides a user with an enabled role at logon. If you do not assign a default role to the user, or if the user wants to enable a different assigned role, the user must submit a SET ROLE request to enable the needed role for the session. See SET ROLE.
- ALL
- Enables all roles currently granted to the user, including any nested roles.
- NONE
- Do not assign a default role to the user.
- NULL
- Do not assign a default role to the user.