Database users

Informix®

Until version 11.70.xC2, Informix database users must be created at the operating system level and must 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.

To get the database user associated to the current SQL connection with Informix, execute the following SQL statement:
DEFINE p_username VARCHAR(50)
SELECT USER INTO p_username FROM systables WHERE tabid=1

IBM® DB2®

With DB2, users must be defined as operating system users with a specific DB2 environment.

The database administrator must grant the CONNECT authority to these users.

  • Database authorities involve actions on a database as a whole. When a database is created, some authorities are automatically granted to anyone who accesses the database. For example, CONNECT, CREATETAB, BINDADD and IMPLICIT_SCHEMA authorities are granted to all users.
  • Database privileges involve actions on specific objects within the database. When a database is created, some privileges are automatically granted to anyone who accesses the database. For example, SELECT privilege is granted on catalog views and EXECUTE and BIND privilege on each successfully bound utility is granted to all 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.

Solution

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

To get the database user associated to the current SQL connection with IBM DB2, execute the following SQL statement:
DEFINE p_username VARCHAR(50)
SELECT CURRENT_USER INTO p_username
   FROM SYSIBM.SYSTABLES WHERE NAME='SYSTABLES'