Granting Privileges to a Role

Grant system privileges to roles at the server or database level.

Prerequisites

See Enabling Granular Permissions.

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 of the Properties view, click Privileges.
  4. In the right pane, click the Database drop-down list and select the database on which you want to grant privileges to the role.
    You can grant server-wide privileges or database privileges in the master database. Server-wide privileges must be granted in the master database.
  5. In the right pane, click Grant.
    Only those privileges that are specific to the selected role and privileges that you are allowed to grant will appear in the Grant Privileges menu.
  6. Select the privilege from the Grant Privileges menu and click OK.
  7. Click Preview to see the SQL statements.

    The following is an example of the SQL preview for granting server-wide privileges. A user with permission to the master database grants the server-wide privilege "Online Database" to a database called "myDatabase."

    set quoted_identifier on

    go

    USE master

    go

    grant Online Database on myDatabase to mon_role

    go

    USE master

    go

    set quoted_identifier off

    go

Related concepts
Enabling Granular Permissions
Related tasks
Revoking Privileges from a Role