Granting Table Permissions

Grant table access permission to users, groups, or roles.

1. In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
2. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
   • User Tables
   • Proxy Tables
3. Select the table on which to set permissions.
4. From the drop-down list, select Properties.
5. Select Permissions.
6. Click Grant to grant access permissions for the selected object.
   You see the Grant Permission wizard.
7. Select the type of grantee:
   • Users
   • Groups
   • Roles
8. Select one or more grantees.
9. Select the columns to set permissions.
10. Select the types of permissions allowed for the selected grantees.

    Option	Description
    Select	Look at information in a table or view
    Insert	Insert rows into a table or view
    Delete	Delete rows from a table or view
    Update	Update rows in a table or view. This may be granted on a set of columns in a table only
    References	Create indexes on a table, and to create foreign keys that reference a table
    Transfer	Incremental transfer. (Available on Adaptive Server 15.5 and higher)
    Identity_insert	(Available when granular permissions is enabled) Explicitly insert a value into an IDENTITY table.
    Identity_update	(Available when granular permissions is enabled) Explicitly update the value of the IDENTITY on a table.

11. (Optional) Click With grant option to allow the specified users to grant object access permissions to other users.
12. (Optional) Click With predicated privileges.
    1. Enter the where search conditions.
       The search conditions act as a row filter, with the where clause specified on select, update, or delete. Search conditions can use all syntax allowed in a generic where clause.
    2. (Optional) Enter a correlation name.
       The correlation name is an alias for referencing columns in the selected table within the where clause.
    3. (Optional) Enter a name for the predicate.
13. (Optional) Click Summary to verify your selected options.