Assigning Logins to a Role

Assign one or more logins to a role.

Prerequisites

To grant or revoke predicated privileges, set the configuration parameter enable predicate privileges to 1.

Task
  1. In the left pane of the Administration Console, expand ASE Servers > Security > Roles.
  2. Click the Name field of the role, then click the drop-down arrow and select Properties.
  3. In the left pane, click Logins.
  4. In the right pane, click Add.
    You see the Add Login to Role window.
  5. Select one or more logins.
  6. (Optional) Click With activation predicate and enter an expression for the activation predicate.
  7. (Optional) Select Active By Default to activate the login account automatically on login.