Granting Privileges to a Role

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

1. In the Perspective Resources view, select the server on which the role resides, then click the drop-down arrow next to the server name and select Administration Console.
2. In the left pane of the Administration Console, expand ASE Servers > Security > Roles.
3. Select a role on which to set privileges.
4. From the drop-down list, select Properties.
   You see the properties window for the role you selected.
5. In the left pane of the Properties view, click Privileges.
6. 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.
7. 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.
8. Select the privilege from the Grant Privileges menu and click OK.
9. 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