17.1 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 olap_user 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