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) » Privileges

 

Granting a system privilege (Sybase Central)

Grant a system privilege to authorize a user or role to perform an operation on the database.

Prerequisites

You must have the administrative rights on the system privilege you want to grant.

 Task

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

  2. Double-click System Privileges and select a system privilege.

  3. In the right pane, click the Grantees tab.

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

  5. Select the user or role that you want to grant the system privilege to.

  6. Click OK.

    A new row is added to the System Privileges table.

  7. (Optional) Use the Adm. (administrative rights) column to change the administrative rights for the system privilege. A checkmark in the column means the user or role can administer (grant or revoke) the system privilege. An empty column indicates that the user or role does not have the administrative rights for the system privilege. 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 system privilege. The exercise privilege is granted by default. Click in the column to toggle the option.

  8. (Optional) If you granted the CHANGE PASSWORD or SET USER system privilege, then the Options column contains All users. The Options column only applies to these two system privileges.

    • If you granted the CHANGE PASSWORD system privilege, then by default the user or role can change the password for any user. To restrict the users whose passwords can be changed, right-click the row and click Set Options.

    • If you granted the SET USER system privilege, then by default the user or role can impersonate any user. To restrict the users who can be impersonated, right-click the row and click Set Options. The Options column only applies to the Change Password and Set User system privileges.

  9. Click File » Save.

Results

The user or role is granted the system privilege(s). If you granted a system privilege to a role, then any user or role that is granted that role inherits the new system privilege.

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