Assign Grants for Config Schema

Config Schema creation requires certain grants for object creation present in the $FIC_HOME/ privileges_config_user.sql file.

To assign grants for the Config Schema, follow these steps by executing in the SQL Plus console:

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
/