Setting privileges

Informix®

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

GRANT CONNECT TO username

Application administration users need the RESOURCE privilege to create tables:

GRANT RESOURCE TO username

Since version 7.20, Informix supports database roles:

GRANT rolename TO username

IBM DB2 supports the concept of roles to grant or revoke permissions to a group of users.

IBM DB2 users must have at least the CONNECT authority to access the database:

GRANT CONNECT ON DATABASE TO { PUBLIC | user | group }

See IBM DB2 documentation for more details.

Informix and IBM DB2 user privileges management are quite similar.