Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » User security (roles and privileges) » Roles » User-defined roles

 

Creating a user-defined role (Sybase Central)

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

Prerequisites

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.

Context and remarks

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

 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, right-click Roles and click New » Role.

  3. Follow the instructions in the wizard.

Results

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.

Next

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

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0