You can set properties, such as read, write, and execute authority, for a query.
To set query properties:
1. In the Queries branch of the desired connection in the DB2 Web Query navigation tree, click the query for which you want to set properties.
The Queries menu appears.
2. From the drop-down menu, select Properties.
The Query Properties page appears.
3. Select a group for the query. To add a new group, enter the name of the group and click Add.
Note: Because each group is associated with an SQL ID, your DB2 administrator must add the desired group to your DB2 installation before you can add the group to DB2 Web Query.
4. If you wish, edit the name of the query.
5. Select a category for the query. To add a new category, enter the name of the category and click Add.
6. If you wish, enter a description of the query.
7. Set permissions for the query.
You can set Read, Write, and Execute permissions for the query. By default, the creator of the query has Read, Write, and Execute permissions. You can specify permissions for other users in the group specified for the query, as well as permissions for all users:
Read |
The user can view the query and the SQL source. |
Write |
The user can modify or delete the query. |
Execute |
The user can run the query. |
8. Click Save.
DB2 Web Query saves the query, and displays a confirmation message.