Granting additional schema privileges individually

To grant additional schema privileges or change Grant options individually:

1. Select the schema or schemas on which you want to grant privileges or change the Grant option.
2. In one or more of the Privileges boxes, select either of these settings:

   Yes

   If the box initially said No, then Yes grants the privilege without the Grant option (the right to grant this privilege to others). If the box initially said Grant, then Yes revokes the privilege and re-grants it without the Grant option.

   As a sign that the grant is pending, a check mark framed by corner brackets appears in the column for this privilege to the right of each selected schema. For example, if you select SCHEMA1 and specify Yes in the CREATEIN box, a check mark framed by corner brackets appears in the CREATEIN column to the right of SCHEMA1.

   Grant

   If the box initially said No, then Grant grants the privilege with the Grant option. If the box initially said Yes, then Grant retains the privilege and adds the Grant option.

   As a sign that the grant is pending, a double check mark framed by corner brackets appears in the column for this privilege to the right of each selected schema. For example, if you select a schema and specify Grant in the ALTERIN box, a double check mark framed by corner brackets appears in the ALTERIN column across from the selected schema.

   The Privileges boxes are:

   • CREATEIN
   • DROPIN
   • ALTERIN
3. Click on Apply. As a sign that the privileges have been granted, the corner brackets disappear, leaving the check marks or double check marks unframed.