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

Oracle® MySQL and MariaDB

MySQL users must be registered in the database:

$ mysql --host orion -u root -p
mysql> create user 'mysuser'@'localhost' identified by 'password';
mysql> grant all privileges on *.* to 'mysuser'@'localhost';

Solution

The solution depends on the application logic, for example, if it is a multi-user application, you have to create one or more MySQL users.

To get the database user associated to the current SQL connection with MySQL, execute the following SQL statement:

DEFINE p_username VARCHAR(50)
PREPARE stmt FROM "SELECT CURRENT_USER()"
EXECUTE stmt INTO p_username