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.

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.