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

 

Granting a role (Sybase Central)

Grant a role to a user or another role.

Prérequis

You must have administrative rights on the role you are granting.

Contexte et remarques

You cannot grant administrative rights on a system role; only users with the MANAGE ROLES system privilege have administrative rights for system roles.

 Task

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

  2. Double-click Users or Roles and select a user or role that you want to grant the role(s) to.

  3. In the right pane, click Grantees.

  4. Right-click anywhere in the right pane and choose New » Grantees.

  5. Click the user or role you want to grant the role to and then click OK.

  6. (Optional) Use the Adm. (administrative rights) column to change the administrative rights for the role. An empty column indicates that the user or role does not have the administrative rights for the role. A checkmark in the column means the user or role can administer (grant or revoke) the role. You cannot grant administrative rights on a system role; only users with the MANAGE ROLES system privilege can administer system roles. Click in the column to toggle the option.

    (Optional) Use the Exe. (exercise rights) column to change the exercise rights for the user or role. A checkmark in the column means the user or role can exercise the role. The exercise privilege is granted by default. Click in the column to toggle the option.

  7. Click File » Save.

Résultat

The role is granted to the user or role.

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0