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

 

Configuring roles and privileges for a role (Sybase Central)

For any role, you can grant roles or privileges to it, revoke roles or privileges from it, and set the administrative rights the role has over the roles and privileges it has been granted.

Prerequisites

If you are granting or revoking a system role you must have the MANAGE ROLES system privilege.

If you are granting or revoking a compatibility role, you must have administration rights for the role.

If you are granting or revoking SYS_RUN_REPLICATION_ROLE, you must have the SYS_REPLICATION_ADMIN_ROLE system 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 Roles and select the role to alter.

    Administrative option Action
    Grant a privilege
    1. In the right pane, click the relevant Privileges tab.

    2. Right-click anywhere in the right pane and click New » Privileges.

    3. Choose one or more privileges from the list and click OK.

    Revoke a privilege
    1. In the right pane, click the relevant Privileges tab.

    2. Right-click the privilege you want to revoke and click Delete.

    Grant a role
    1. In the right pane, click the Roles tab.

    2. Right-click anywhere in the right pane and click New » Granted Roles.

    3. Choose one ore more roles to grant and click OK.

    Revoke a role
    1. In the right pane, click the Roles tab.

    2. Right-click the role you want to revoke and click Delete.

  3. Click File » Save.

Results

The role is configured.

 See also