Granting privileges to a new user ID

1. Open the Privileges window of the object for which you want to add a new user ID.
2. Click the Add User ID push button to add a new row to the privilege table.
3. Type a user ID, or click on the ellipsis to use the List User IDs window to locate an existing user ID.
4. To grant all privileges but not the authority to grant privileges to other users, click Allow.
5. To grant all privileges and authority to grant privileges to other users, click Grant.
6. To grant selected privileges, click the cells for the privileges that you want, then click either Grant or Allow.
7. Optional. To give a user ID privileges on only selected columns in a table, click Enable column privileges, and select the columns you want.
8. Click OK to add the changes and close the window.

Changing privileges for an existing userID

To change privileges:

1. Open the Privileges window of the object for which you want to change a user's privileges.
2.  Highlight the user ID whose privileges you want to change.
3. To grant all privileges but not the authority to grant privileges to other users, click Allow.
4. To grant all privileges and authority to grant privileges to other users, click Grant.
5. Optional. To give a user ID privileges on only selected columns in a table, click Enable column privileges, and select the columns you want.
6. To revoke privileges the user ID has, click the appropriate cells, then click Revoke.
7. Click OK to save the changes and close the window.