Granting Table Permissions

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

Table owners and database owners can grant database object permissions on a table.

  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. 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.
  11. (Optional) Click Summary to verify your selected options.
Related tasks
Revoking Table Permissions