Skip to content

Update Users

Only users in the useradmin group have the privilege to maintain other users.

To update a user, connect as the userdamin privileged user to User Management database (iidbdb) where the users are maintained, and execute an ALTER USER query.

Note

The following example assumes connection to the User Management database (iidbdb). See examples of connections in Overview of User Management.

Example

alter user testuser2 with profile=useradmin, group=dbadmingrp;

This example updates testuser2 (from Add Native Users, Example 2) to have privileges to maintain users by assigning a useradmin profile and adding testuser2 to dbadmingrp, allowing the user to read and write access to the sample data.

More information:

ALTER USER