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 an object-level privilege (Sybase Central)

Grant object-level privileges to allow access to a specific object, such as a table, view, procedure, sequence, or dbspace. You can view and change privileges either per user, role, or database object.


To grant an object-level privilege, one of the following must be true:

  • You are the owner of the database object you are granting privileges for.

  • You have been granted the privilege and have administrative rights on it.

  • You have the MANAGE ANY OBJECT PRIVILEGE system privilege.

Context and remarks

When you grant privileges to roles, they are inherited by the members of the role.

  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 a user.

  3. In the right pane, click the appropriate privileges tab. For example, to grant privileges on a table click the Table Privileges tab.

    The tab lists the privileges that the user has been explicitly granted.

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

  5. Select the database objects(s) that you want to grant privileges on and then click OK.

    The database object is added as a row to the tab. By default, all privileges for the database object are granted.

  6. (Optional) To modify the privileges granted to the user on a database object, click the relevant cell in the table that appears in the appropriate Privileges tab (see the legend for cell definitions).

    A checkmark grants the privilege to the user. A checkmark with a plus sign (+) grants the privilege to the user and grants the user the privilege to grant the same privilege to other users. A checkmark with a plus sign (+) is equivalent to executing the GRANT statement with the WITH GRANT OPTION clause.

    In the Table Privileges tab, when you select a table, the corresponding Column Privileges table appears below. Modifying a column privilege causes the Column privileges are granted/granted with grant option icon to appear in the Table Privileges table. Modifying table privileges affects whether specific column privileges can be granted.

    • To undo your changes, select one or more rows on the Privileges tab and click Edit » Undo.

    • To turn the Legend on or off, click File » Show Legend.

  7. Click File » Save.


The user is granted the specified object-level privilege(s).

 See also