Contents Index Granting permissions on views Granting permissions on procedures

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

Granting users the right to grant permissions


You can assign each of the table and view permissions described in Granting permissions on tables with the WITH GRANT OPTION. This option gives the right to pass on the permission to other users. In the context of groups, you can read about this feature in section Permissions of groups.

In Sybase Central, you can specify a grant option by displaying the property sheet of a user, group, or table, clicking the Permissions tab, and double-clicking in the fields provided so that a check mark with two '+' signs appears.

Example 

You can grant permission to M_Haneef to delete rows from the table named sample_table, and the right to pass on this permission to other users, as follows:

  1. Connect to the database as a user with DBA authority, or as the owner of sample_table:

  2. Type and execute the SQL statement:

    GRANT DELETE ON sample_table
    TO M_Haneef
    WITH GRANT OPTION

For more information, see GRANT statement


Contents Index Granting permissions on views Granting permissions on procedures