Granting any schema privileges individually

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

1. List the schema:

   1. Click on Add schema. The Add Schema window opens.

   2. Select the schemas on which you want to grant privileges.

   3. Click on Add. The selected schemas are listed in the Schema column. In addition, Xs appear in the privileges columns and the Privileges boxes specify No. The Xs and Nos mean that the group doesn't have any privileges on the selected schemas.

   4. Repeat steps b and c to add additional schemas.

   5. Click on Close in the Add Schema window. The window closes.

2. In the Schema box, select one or more of the schemas that you listed.

3. 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

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

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]