The system security officer or user assigned the role can determine
whether to activate roles granted by default at login.
Roles may or may not be active at login, depending on the default set for a role.
In the Administration Console, select a server, click the drop-down
arrow, and select Role Activation.
To activate or deactivate a role, select or unselect its Activate role check box.
Activate roles only when you need them, and turn them off when you
no longer need them. For example, when the sa_role is active, you assume the
identity of database owner within any database that you use.
Supply a password if the role requires a password to be activated.