Permissions for administering Informix Warehouse Accelerator

You must have permissions to administer Informix® Warehouse Accelerator.

To administer Informix Warehouse Accelerator with SQL routines, Java™ classes, the IBM® OpenAdmin Tool (OAT) for Informix, and the Informix Smart Analytics Optimizer Studio, you must be user informix and have the WAREHOUSE privilege.

WAREHOUSE privilege

You grant the WAREHOUSE privilege by running the admin() or task() function with the grant admin and WAREHOUSE arguments. For example, the following statement, run in the sysadmin database, grants the user Bob the WAREHOUSE privilege:

EXECUTE FUNCTION task("grant admin", "Bob", "WAREHOUSE");

If the first Informix Warehouse Accelerator routine is run in a new database, the EXTEND role, RESOURCE role, and language-level privileges permissions are required. When a routine is run in a new database, the initial creation of all Informix Warehouse Accelerator functions and procedures is triggered. For subsequent runs these permissions are not required.

EXTEND role privilege

If IFX_EXTEND_ROLE=1 in the onconfig file, you must grant the EXTEND role privilege to all users besides informix and the DBA role, that perform Informix Warehouse Accelerator functions and procedures in your database. For example, this statement grants the EXTEND role to user Bob:

GRANT EXTEND TO 'Bob';

RESOURCE role and language-level privileges

If IFX_EXTEND_ROLE=0 in the onconfig file, you must grant the RESOURCE role and language-level privileges to all users besides informix that perform Informix Warehouse Accelerator functions and procedures in your database. For example, these statements grant the RESOURCE role and language-level privileges to user Bob:

GRANT RESOURCE TO 'Bob';
GRANT USAGE ON LANGUAGE C TO 'Bob';

Additional routine-specific permissions might be required and are documented in the individual routines.