Changing DB users

Use the Change DB Users window to add a new user ID and to grant privileges to the user ID for the objects in the Control Center.

Both the DB User window and the Privileges window identify privileges granted to user IDs, and let you grant or revoke privileges to user IDs. DB User windows focus on individual user IDs and the privileges granted to these user IDs. The Privileges windows list user IDs that have privileges for an object.

Authorities and privileges

To create a new DB User ID:

1. Open the Create DB User window.
2. In the User name field, type a 1-8 character user ID.
3. Click the tab for the type of object for which you want to grant privileges to the user ID.
4. Optional: To add a new object on any page, click the Add [object] push button to create a new row in the table. For example, if you want to add a buffer pool, click the Add Buffer Pool push button as described in this example.
5. Use one of the following methods to grant privileges to the user:
   • Right-click in the cells for the privileges that you want, then select either Allow or Allow with Grant from the menu.
   • Select as many privileges as you want, then click either the Grant push button, or the Allow push button. You select multiple cells by holding the Ctrl key while selecting the cells.
6. Optional: Repeat step 3 to step 5 to grant privileges to the user ID for additional objects.
7. Click OK to save your changes and close the window.

About granting and revoking privileges