Granting Roles to a Login

Add roles to login accounts.


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

  1. In the left pane of the Administration Console, expand ASE Servers > Security > Logins.
  2. Click the Name field of the login, then click the drop-down arrow and select Properties.
  3. In the left pane, click Roles.
  4. In the right pane, click Add.
    You see the Add Roles to Login window.
  5. Select one or more roles.
  6. (Optional) Click With activation predicate and enter an expression for the activation predicate.
  7. (Optional) Select Active By Default to indicate the role must be automatically activated on login.
Related tasks
Managing Users Mapped to Logins
Assigning Login Profiles to a Login
Removing Roles from a Login