Granting Delete Permission on Tables and Views in Interactive SQL

All table and view permissions are granted in a very similar fashion.

Use the GRANT statement to grant permissions. For example, to grant permission to M_Haneef to delete rows from the table named sample_table:

  1. Connect to the database as a user with DBA or PERMS ADMIN authority, or as the owner of sample_table.
  2. Type and execute the SQL statement:
    GRANT DELETE
ON sample_table
TO M_Haneef
Parent topic: Permissions on Tables and Views
Related concepts
Permissions of Groups
Related tasks
Granting Permissions on Procedures in Interactive SQL
Granting Permissions on Procedures in Sybase Central
Granting the Right to Grant Permissions
Granting Update Permission on Tables and Views in Interactive SQL
Granting User Permission on Tables in Sybase Central