Activating a Role

The System Security Officer or user can determine whether to activate roles granted by default at login.

Roles must be active to have the access privileges of each role. Depending on the default set for a role, the role may or may not be active at login.

  1. In the Administration Console, select a server, click the drop-down arrow, and select Role Activation.
  2. To activate or deactivate a role, click in the Activate role check box.

    You should 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.
Parent topic: Managing an Adaptive Server