17.2 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 olap_user to &database_username
/
grant select on SYS.V_$PARAMETER to &database_username
/
grant create SYNONYM to &database_username
/