K Grants for Atomic/Config Schema

This section describes the various grants required for the CONFIG, ATOMIC schemas.

Configuring Grants for Atomic Schema

Atomic Schema creation requires certain grants for object creation. This can be located in $FIC_HOME/ privileges_atomic_user.sql file. The following are the Grants for Atomic Schema:

grant create SESSION to &database_username

/

grant create PROCEDURE to &database_username

/

grant create SEQUENCE to &database_username

/

grant create TABLE to &database_username

/

grant create TRIGGER to &database_username

/

grant create VIEW to &database_username

/

grant create MATERIALIZED VIEW to &database_username

/

grant select on SYS.V_$PARAMETER to &database_username

/

grant create SYNONYM to &database_username

/

Note:

If you intend to use Oracle OLAP feature, execute the following grant on all ATOMIC schema(s):

grant olap_user to &database_username

Configuring Grants for Config Schema

Config Schema creation requires certain grants for object creation. This can be located in

$FIC_HOME/privileges_config_user.sql file.

The following are the Grants for Config Schema:

grant create SESSION to &database_username

/

grant create PROCEDURE to &database_username

/

grant create SEQUENCE to &database_username

/

grant create TABLE to &database_username

/

grant create TRIGGER to &database_username

/

grant create VIEW to &database_username

/

grant create MATERIALIZED VIEW to &database_username

/

grant select on SYS.V_$PARAMETER to &database_username

/

grant create SYNONYM to &database_username

/

Configuring Grants for Config Schema Entities for Atomic Users

Atomic Schema creation requires certain grants for config schema object access. This can be located in $FIC_HOME/config_table_privileges_for_atomic_user.sql file.