Granting all schema privileges at one time

To grant all privileges on a schema at the same time:

1. Select the schema or schemas that you want to grant privileges on.
2. Click on Grant all. The Select Grant Option window opens.
3. Select a radio button to indicate whether you want to provide the Grant option (the right to grant privileges on the selected schema or schemas to other users and to groups).

   With Grant option

   Provides the Grant option

   No Grant option

   Withholds the Grant option

4. Click on OK.

   If you selected With Grant option:

   • The Xs across from the selected schemas are replaced by double check marks framed by corner brackets. The brackets indicate that the grant of the privileges, with the Grant option, is pending.
   • The Privileges boxes specify Grant.

   If you selected No Grant option:

   • The Xs across from the selected schemas are replaced by check marks framed by corner brackets. The brackets indicate that the grant of the privileges, without the Grant option, is pending.
   • The Privileges boxes specify Yes.