ASA Database Administration Guide
  Managing User IDs and Permissions
    Managing individual user IDs and permissions

Revoking user permissions

Any user's permissions are a combination of those that have been granted and those that have been revoked. By revoking and granting permissions, you can manage the pattern of user permissions on a database.

The REVOKE statement is the exact converse of the GRANT statement. To disallow M_Haneef from executing my_procedure, the command is:

REVOKE EXECUTE
ON my_procedure
FROM M_Haneef

The DBA or the owner of the procedure must issue this command.

Permission to delete rows from sample_table may be revoked by issuing the command:

REVOKE DELETE
ON sample_table
FROM M_Haneef

For more information on using Sybase Central to grant or revoke permission, see the following sections:

• Granting permissions on tables

• Granting permissions on views

• Granting permissions on procedures