Granting and Revoking Table Permissions

Use the Permissions page of the Table Schema Editor to grant and revoke privileges to a table. You can also view table privileges.

1. Right-click the table and select Edit to open the Table Schema Editor.
2. Select the Permissions page.

   The Permissions page displays the table access privileges categorized by user, group, and role. All of the users in the current database are listed under the Users node. The groups in the current database are listed under the Groups node, and all of the roles (including system roles and user-defined roles) are listed under the Roles node.

3. Change the privileges for a user, group, or role:

   Option	Description
   Empty	No privileges. If the current state is empty, you can select G or GO to grant privileges to a user, group, or role.
   G	Granted. User has privileges on the table but cannot grant the privilege to other users. If privileges are set to G, you can leave the option empty to revoke the privilege or select GO to grant the grant option.
   GO	Granted with grant option. User has privilege on the table and can grant the privilege to other users.
   I	Inherited. Similar to G, but the privilege is inherited from the group.
   RI	Revoked inherited permission. The inherited privilege from the group is revoked.

4. Save your changes and close the table.

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com