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.