Defining database users

Until version 11.70.xC2, Informix® database users had to be created at the operating system level and be members of the 'informix' group. Starting with 11.70.xC2, Informix supports database-only users with the CREATE USER instruction, as in most other db servers. Any database user must have sufficient privileges to connect and use resources of the database; user rights are defined with the GRANT command.

IBM® DB2® users are operating system users with a specific DB2 environment. The database administrator must grant the CONNECT authority to these users.

Together, privileges and authorities act to control access to an instance and its database objects. Users can access only those objects for which they have the appropriate authorization, that is, the required privilege or authority.

Note: As in Informix, DB2 user names that connect to the database server must be a maximum of eight characters long.

Solution

Set up the IBM DB2 environment for each user as described in the documentation.