Creating a user-defined role (Sybase Central)

Create a role, and grant roles and privileges to it.

Prérequis

You must have the MANAGE ROLES system privilege.

The name you assign to the new role cannot begin with the prefix SYS_ and end with the suffix _ROLE. For example, SYS_MyBackup_ROLE cannot be the name of a user-defined role.

Contexte et remarques

You can also convert an existing user into a user-extended role, and then grant the user-extended role to other users.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, right-click Roles and click New » Role.
Follow the instructions in the wizard.

Résultat

A new role is created. By default, you are the owner of the role and the role is granted to the MANAGE ROLES system privilege.

Suivant

Grant system privileges to this role and grant this role to other users.

Creating a user-defined role (Sybase Central)

Task

See also