You can set properties, such as DB2 permissions, for a table.
To set table properties:
1. In the Tables branch of the DB2 Web Query navigation tree, click the table for which you want to set properties.
The Tables menu appears.
2. From the drop-down menu, select Properties.
The Table Properties page appears.
3. If you wish, enter a description of the table.
4. Select the permission you want to grant from the Privileges list.
Existing grantees for each privilege appear in the Grantees list.
5. Select the SQL ID to which you want to grant permissions from the dropdown menu. If desired, select the With Grant Option box. This option gives the selected ID the power to grant the selected permission to other users.
Tip: To add an ID to the dropdown menu, enter it in the New ID field and click Add.
6. Click Grant To. The selected SQL ID appears in the Grantees list for that privilege. If you have selected the With Grant Option box, a (G) appears after the ID.
7. To revoke permissions, select the desired privilege from the Privileges list and the desired ID from the Grantees list. Click Revoke.
A confirmation message appears.
8. Click Update.
DB2 Web Query updates the table properties in the database. The message page opens, displaying a confirmation message.