Granting all additional schema privileges at one time

To grant all additional schema privileges in one operation:

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

2. Click on Grant all. The Select Grant Option window opens.

3. Select a radio button to indicate whether you want the group to have the Grant option--the right to grant a privilege to other users and groups--on all schema privileges:

   With Grant option

   Provides the Grant option.

   No Grant option

   Withholds the Grant option. If the group already has any privileges with the Grant option on any selected schema, No Grant option revokes these privileges and re-grants them without the option.

4. Click on OK. If you selected With Grant option:

   • In each column that contains an X or check mark across from the selected schema or schemas, the X or check mark is replaced by a double check mark framed by corner brackets. This new symbol means that the grant of a privilege, with the Grant option, is pending.

   • The Privileges boxes specify Grant.

   If you selected No Grant option:

   • In each column that contains an X or double check mark across from the selected schema or schemas, the X or double check mark is replaced by a single check mark framed by corner brackets. This new symbol means that a grant of a privilege, without the Grant option, is pending.

   • The Privileges boxes specify Yes.

5. Click on Apply. As a sign that the privileges have been granted, the corner brackets disappear, leaving the single or double check marks unframed.