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 commands in the SQL tool 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
/