Granting users the right to grant permissions to other users

For tables and views you can grant a user the permission to grant the same permission to other users. You use the WITH GRANT OPTION with the GRANT statement to grant users this permission. The permission to grant the same permission to other users is not inherited by members of a group.

Members of a group can inherit only the following permissions for the group they belong to:

 Grant permissions on tables and views and grant the same permissions to other users (SQL)
  1. Connect to the database as a user with DBA authority or as the user who owns the table or view.

  2. Execute a GRANT statement with the WITH GRANT OPTION to assign the permission. See GRANT statement.

    For example:

    GRANT DELETE ON sample_table
    TO M_Haneef
    WITH GRANT OPTION;
 Grant permissions on tables and views and to grant the same permissions to other users (Sybase Central)
 See also