Granting any table privileges individually

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

1. List the table:

   1. Click on Add Table. The Add Table window opens.

   2. Use the Schema box to specify a schema that includes tables that you want to grant privileges on. A list of the schema's tables appears in the Table list box.

   3. Select the table or tables that you want.

   4. Click on Add. The selected table or tables are listed in the Table 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 table or tables.

   5. Optional: Repeat steps b, c, and d to add tables in another schema.

   6. Click on Close in the Add Table window. The window closes.

2. In the Tables box, select one or more of the tables 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 table. For example, if you select TABLE4 and specify Yes in the ALTER box, a check mark framed by corner brackets appears in the ALTER column to the right of TABLE4.

   Grant

   Grants the privilege with the Grant option (not available for CONTROL).

   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 table. For example, if you select TABLE5 and specify Grant in the INDEX box, a double check mark framed by corner brackets appears in the INDEX column to the right of TABLE5.

   The Privileges boxes are:

   • SELECT

   • INSERT

   • UPDATE

   • DELETE

   • CONTROL

   • ALTER

   • INDEX

   • REFERENCES

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

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

[ DB2 List of Books | Search the DB2 Books ]