Setting privileges

Informix® and Genero db user privileges management are similar.

Genero db provides roles to group privileges which then can be assigned to users. Starting with version 7.20, Informix also provides roles.

Informix users must have at least the CONNECT privilege to access the database:

GRANT CONNECT TO (PUBLIC|user) 

To be able to create tables, views or synonyms, Genero db users need:

GRANT CREATE TABLE TO user
GRANT CREATE VIEW TO user
GRANT CREATE SYNONYM TO user 
Note: Genero db does NOT provide the Informix CONNECT, RESOURCE and DBA roles.

Solution

In Genero db, roles can be created with database privileges to simulate Informix system roles.