Assign Grants for Atomic Schema

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

To assign grants for the Atomic 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 select on SYS.V_$PARAMETER to &database_username
/
grant create SYNONYM to &database_username
/