Grant privileges to roles

As DBA, you can create roles to standardize the privileges given to a class of users. When you assign privileges to that role, every user of that role has those access privileges. The SQL statements used for defining and manipulating roles include: CREATE ROLE, DROP ROLE, GRANT, REVOKE, and SET ROLE. For more information on the SQL syntax statements for defining and manipulating roles, see the HCL® Informix® Guide to SQL: Syntax.

Default roles automatically apply upon connection to the database for particular users and groups, without requiring the user to issue a SET ROLE statement. For example:
GRANT DEFAULT ROLE manager TO larry;

For more information on roles and default roles, see Control database use or see the HCL® Informix® Administrator's Guide.

For more information on granting and revoking privileges, see Grant and revoke privileges in applications. Also see IBM® Informix® Database Design and Implementation Guide.