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=1Netezza®
Netezza users must be registered in the database with
the
CREATE USER command, for
example:CREATE USER name WITH PASSWORD 'pswd' IN GROUP ...See the Netezza documentation for more details about user creation and database access/security.
Solution
Depending on the application logic (is it a multiuser application?), you have to create one or several Netezza users.
To get the database user associated to the current SQL connection with Netezza, execute the following SQL
statement:
DEFINE p_username VARCHAR(50)
PREPARE stmt FROM "SELECT CURRENT_USER"
EXECUTE stmt INTO p_username