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. Select ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  2. Select the table on which to set permissions.
  3. Select Properties.
  4. From the Table Properties window, select Permissions.
    You see the Permissions window.
  5. Click Grant to grant access permissions for the selected table.
    You see Permissions wizard.
  6. Select the type of grantee:
    • Users
    • Groups
    • Roles
  7. Select one or more grantees.
  8. Select the columns to set permissions.
  9. Select the types of permissions allowed for the selected grantees.
  10. (Optional) Click Summary to verify your selected options.
Related tasks
Revoking Table Permissions