Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » Context-Sensitive Help » SQL Anywhere plug-in help » Introduction to SQL Anywhere properties windows

 

Table Properties window: Permissions tab

This tab has the following components:

  • Permissions list   Lists the users who have permissions on the table. If you want to add users to the list, click Grant. To remove a user from the list, select the user, then click Revoke. You can select multiple users by holding Shift while you click.

To grant or revoke permissions, click the fields beside each user. Double-clicking (so that a check mark and two + signs appear) gives the user grant options.

  • Grant   Displays the Grant Permission window, which lets you grant permissions on the table to other users.

  • Revoke   Revokes permissions from the users and removes them from the Permissions list.

  • Select   Shows whether the select permissions for the user applies to all columns or a subset of columns. Click Change to grant Select permissions for a subset of columns.

  • Update   Shows whether the update permissions for the user applies to all columns or a subset of columns. Click Change to grant Update permissions for a subset of columns.

  • References   Shows whether the reference permissions for the user applies to all columns or a subset of columns. Click Change to grant Reference permissions for a subset of columns.

  • Change   Click Change to grant select, update, or reference permissions for a subset of columns.

 See also