Granting users the right to grant permissions

Each of the table and view permissions described in “Granting permissions on tables and views” can be assigned WITH GRANT OPTION. This option gives the right to pass on the permission to other users. This feature is discussed in the context of groups in “Permissions of groups”.

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