Granting 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 IBM 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 Controlling Database Use or see the IBM Informix: Administrator's Guide.

For more information on granting and revoking privileges, see Granting and Revoking Privileges in Applications. Also see IBM Informix: Database Design and Implementation Guide.