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
/