Granting any schema privileges individually

If the user doesn't have any privileges on a schema, and you want to grant the user any of those privileges individually:

1. Click on Add schema. The Add Schema window opens.
2. In the Add Schema window, select the schemas on which you want to grant privileges.
3. Click on Apply. As a result:
   • The schemas you selected are listed in the Schema column on the Schema page.
   • Xs appear beside these schemas in the privileges columns. In addition, the Privileges boxes specify No. The Xs and Nos mean that the selected user has no privileges on the schemas that you selected.
4. Repeat steps 2 and 3 to add additional schemas.
5. Click on Cancel in the Add Schema window. The window closes.
6. In the Schema box, select one or more of the schemas that you had selected in the Add Schema window.
7. In one or more of the Privileges boxes, select either of these settings:

   Yes

   Grants the privilege 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 SCHEMA4 and specify Yes in the CREATEIN box, a check mark framed by corner brackets appears in the CREATEIN column to the right of SCHEMA4.

   Grant

   Grants the privilege with 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 SCHEMA5 and specify Grant in the ALTERIN box, a double check mark framed by corner brackets appears in the ALTERIN column to the right of SCHEMA5.

   The Privileges boxes are:

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