| SQL adaptation guide for IBM Netezza 6.x / Database concepts | |
Until version 11.70.xC2, Informix® database users must be created at the operating system level and 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 the resources of the database; user rights are defined with the GRANT command.
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.
According to the application logic (is it a multiuser application?), you have to create one or several Netezza users.