SQL adaptation guide For Genero db 3.6x, 3.8x / Database concepts |
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
In Genero db, roles can be created with database privileges to simulate Informix system roles.