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

SAP HANA®

Typically, SAP HANA users must have schema privileges to access the database table of a schema created by the application administrator.

SAP HANA supports concept of roles, to define common user privileges.

Solution

Informix and SAP HANA® user privileges management is quite similar.