Changing DB users

Use the Change DB Users window to grant or change privileges to a user ID for objects.

Both the DB User window and the Privileges window identify privileges granted to user IDs, and let you grant or revoke privileges to users IDs. The difference between them is that the DB User windows focus on individual users and the privileges granted to the users IDs. The Privileges windows show objects and list users IDs that have privileges for those objects.

Authorities and privileges

To change privileges for a DB user:

1. Open the Change DB User window.
2. Click the notebook tab for the type of object for which you want to change privileges.
3. Optional: To add a new object, 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.
4. Use one of the following methods to change privileges to the user ID:
   • Right-click in the cell for the privilege that you want, then select Allow, Grant , or Revoke from the menu.
     
   • Select the privileges that you want from the menu, then click either the Grant push button, the Allow push button, or the Revoke push button. You select multiple cells by holding the Ctrl key while selecting the cells.
5. Optional: Repeat step 2 through 4 for each type of object that you want to change user ID privileges for.
6. Click OK to save your changes and close the window.

About granting and revoking privileges