Granting User Permission on Tables in Sybase Central

One way to grant a user permissions on a table in Sybase Central is as follows:

Connect to the database.
Double-click the Tables folder for that database, to display the tables in the left panel.
Right-click a table and choose Properties from the popup menu.
On the Permissions tab of the Properties dialog, configure the permissions for the table:
- Click Grant to select users or groups to which to grant full permissions.
- Click in the fields beside the user or group to set specific permissions. Permissions are indicated by a check mark, and grant options are indicated by a check mark with two ‘+’ signs.
- Select a user and click the button beside References, Select, or Update to set that type of permission on individual columns.
- Select a user or group in the list and click Revoke to revoke all permissions.

You can also assign permissions from the Users & Groups property sheet. To assign permissions to many users and groups at once, use the table’s property sheet. To assign permissions to many tables at once, use the user’s property sheet.