Warehouse User Guide > Warehouse and Database Management > Manage Users > Update Users
Was this helpful?
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
Last modified date: 12/12/2024