Granting all schema privileges at one time

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

1. Select the schema or schemas on which you want to grant the privileges.

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.