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
SQLite
SQLite does not have the database users concept.
However, the operating system user must have read/write access to the database file.
Solution
SQLite is mainly designed for single-user applications.