Activating a Role

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.

  1. In the Administration Console, select a server, click the drop-down arrow, and select Role Activation.
  2. 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.

  3. Supply a password if the role requires a password to be activated.