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-extended roles

 

Converting a user to a user-extended role (Sybase Central)

Change a user to a user-extended role, which can then be granted to other users and roles. User-extended roles are convenient when you have a user with a desired set of system privileges and roles that you also want to grant to another user.

Prerequisites

You must have the MANAGE ROLES privilege.

Context and remarks

The user who has become a user-extended role can administer the new role (grant and revoke it to others) unless this privilege is explicitly removed. Also, users with the MANAGE ROLES system privileges can administer the role.

 Task

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

  2. In the left pane, double-click Users and select the user.

  3. Right-click the user and then click Change to User-extended Role.

Results

The user is extended into a role. A Grantees tab appears in the right pane, and new role appears in the list of roles in the left pane.

Next

You can grant the new role to other users and roles. When you grant a user-extended role to a user or another role, the grantee inherits all the system and object-level privileges that the user-extended role has, including any administrative rights.

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