Assign Grants for Schemas

This section discusses the various grants required for the Atomic and Sandbox schemas.

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, execute the following script 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
/

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, execute the following script 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
/

Assign Grants for Config Schema Entities for Atomic Users

Atomic Schema creation requires certain grants for config schema object access present in the $FIC_HOME/config_table_privileges_for_atomic_user.sql file. To assign grants for the Config Schema entities for Atomic Users, execute the following script in the SQL Plus console:

grant select on CSSMS_USR_PROFILE to &database_username
/
grant select on CSSMS_ROLE_MAST to &database_username
/
grant select on CSSMS_GROUP_MAST to &database_username
/
grant select on CSSMS_FUNCTION_MAST to &database_username
/
grant select on CSSMS_USR_GROUP_MAP to &database_username
/
grant select on CSSMS_USR_GROUP_DSN_SEG_MAP to &database_username
/
grant select on CSSMS_ROLE_FUNCTION_MAP to &database_username
/
grant select on CSSMS_GROUP_ROLE_MAP to &database_username
/
grant select on CSSMS_SEGMENT_MAST to &database_username
/
grant select on CSSMS_USR_DSN_SEG_MAP to &database_username
/
grant select on CSSMS_USR_ROLE_MAP to &database_username
/
grant select on CSSMS_METADATA_SEGMENT_MAP to &database_username
/
grant select on BATCH_RUN to &database_username
/
grant select on PR2_FILTERS to &database_username
/
grant select on PR2_TASK_FILTER to &database_username
/
grant select on PR2_TASK_FILTER_DETAIL to &database_username
/
grant select on ST_STRESS_MASTER to &database_username
/
grant select on ST_SCENARIO_MASTER to &database_username
/
grant select on ST_SHOCK_MASTER to &database_username
/
grant select on BATCH_MASTER to &database_username
/
grant select on ICC_MESSAGELOG to &database_username
/
grant select on PR2_MASTER to &database_username
/
grant select on PR2_RUN_REQUEST to &database_username
/
grant select on MF_MODEL_SCRIPT_MASTER to &database_username
/
grant select on MF_INPUT_VALUES to &database_username
/
grant select on MF_MODEL_OUTPUT_VALUES to &database_username
/
grant select on DB_MASTER to &database_username
/
grant select on DSNMASTER to &database_username
/
grant select on pr2_rule_map to &database_username
/
grant delete on pr2_rule_map_pr to &database_username
/
grant insert on pr2_rule_map_pr to &database_username
/
grant update on pr2_rule_map_pr to &database_username
/
grant select on pr2_rule_map_pr to &database_username
/
grant delete on pr2_rule_map_pr_tmp to &database_username
/
grant insert on pr2_rule_map_pr_tmp to &database_username
/
grant update on pr2_rule_map_pr_tmp to &database_username
/
grant select on pr2_rule_map_pr_tmp to &database_username
/
grant select on pr2_rule_map_exclude to &database_username
/
grant delete on pr2_rule_map_exclude_pr to &database_username
/
grant insert on pr2_rule_map_exclude_pr to &database_username
/
grant update on pr2_rule_map_exclude_pr to &database_username
/
grant select on pr2_rule_map_exclude_pr to &database_username
/
grant delete on pr2_rule_map_exclude_pr_tmp to &database_username
/
grant insert on pr2_rule_map_exclude_pr_tmp to &database_username
/
grant update on pr2_rule_map_exclude_pr_tmp to &database_username
/
grant select on pr2_rule_map_exclude_pr_tmp to &database_username
/
grant select on pr2_run_object to &database_username
/
grant select on pr2_run_object_member to &database_username
/
grant select on pr2_run_map to &database_username
/
grant select on pr2_run_execution_b to &database_username
/
grant select on pr2_run_execution_filter to &database_username
/
grant select on pr2_firerun_filter to &database_username
/
grant select on pr2_filters to &database_username
/
grant select on configuration to &database_username
/
grant select on batch_parameter to &database_username
/
grant select on component_master to &database_username
/
grant select on MDB_OBJECT_TYPE_ATT_LAYOUT to &database_username
/
grant select on REV_OBJECT_ATTRIBUTE_DTL to &database_username
/
grant select on FORMS_LOCALE_MASTER to &database_username
/
grant select on mdb_object_dependencies to &database_username
/
grant select on mdb_execution_details to &database_username
/
grant select on REV_STAT_DATA to &database_username
/
grant select on REV_OBJECT_REPOSITORY_B to &database_username
/
grant select on REV_OBJECT_REPOSITORY_TL to &database_username
/
grant select on REV_OBJECT_ATTRIBUTE_DTL_MLS to &database_username
/
grant select on REV_OBJECT_APPLICATION_MAP to &database_username
/
grant select on MDB_OBJ_EXPR_DETAILS to &database_username
/
grant select on MDB_EXECUTION_DETAILS to &database_username
/
grant select on REV_OBJECT_TYPES_CD to &database_username
/
grant select on REV_OBJECT_TYPES_MLS to &database_username
/
grant select on REV_APPLICATIONS_CD to &database_username
/
grant select on REV_APPLICATIONS_MLS to &database_username
/
grant select on METADATA_BROWSER_LOCALE to &database_username
/
grant select on MDB_STAT_DATA to &database_username
/
grant select on MDB_OBJECT_TYPE_LAYOUT to &database_username
/
grant select on ofsa_md_id_ref to &database_username
/
grant select on MDB_ETL_MAPPING to &database_username
/
grant select on setupinfo to &database_username
/
grant select on LOCALEREPOSITORY to &database_username
/
grant select on MF_MODEL_MASTER to &database_username
/
grant select on MF_SANDBOX_MASTER to &database_username
/
grant select on MF_VARIABLE_MASTER to &database_username
/
grant select on MF_TECHNIQUE_MASTER to &database_username
/
grant select on MDB_RULE_SOURCE_HEADER to &database_username
/
grant select on MDB_RULE_TARGET_HEADER to &database_username
/
grant select on MDB_RULE_TARGET_MEMBER_HEADER to &database_username
/
grant select on MDB_RULE_GRID_DATA to &database_username
/
grant select on MDB_MODEL_MAPPING to &database_username
/
grant delete on AAI_MAP_MAPPER to &database_username
/
grant insert on AAI_MAP_MAPPER to &database_username
/
grant update on AAI_MAP_MAPPER to &database_username
/
grant select on AAI_MAP_MAPPER to &database_username
/
grant select on RTI_UI_EXCLUDE_PDM_LISTto &database_username
/
grant select on RTI_VIR_PHY_TBL_NAMEto &database_username
/
grant select on infodom_patches to &database_username
/