set verify off
DEFINE role_prefix = SIM201


--Grants to Tables
GRANT SELECT, DELETE ON SIM_ACTIVITY_CPORG TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_ACTIVITY_PERSONNEL TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_ACTIVITY_PROJECTS TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_ACTUAL_ACTIVITY_LOC TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_BIO_RESULTS_GRP TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_BIO_RESULTS_GRP_INDIVIDUAL TO &&role_prefix._USER_ROLE;
GRANT SELECT, INSERT, UPDATE, DELETE ON SIM_CONFIG TO &&role_prefix._USER_ROLE;
GRANT SELECT, INSERT, UPDATE ON SIM_COPY_LOG TO &&role_prefix._USER_ROLE;
GRANT SELECT, INSERT ON SIM_COPY_LOG_DETAILS TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_ESTUARY_LOC TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_EXPORT_DETAILS TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_EXPORT_LOG TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_FIELD_ACTIVITIES TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_FIELD_ACTIVITY_PARENT TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_GREAT_LAKE TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_HELP TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_ALLOW_VALUES TO &&role_prefix._USER_ROLE;
GRANT SELECT, INSERT, UPDATE, DELETE ON SIM_IMP_CFG TO &&role_prefix._USER_ROLE;
GRANT SELECT, INSERT, UPDATE, DELETE ON SIM_IMP_CFG_DETS TO &&role_prefix._USER_ROLE;
GRANT SELECT, INSERT, UPDATE, DELETE ON SIM_IMP_CFG_INSTRS TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_COLS TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_DEFS TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_FMT_CHOICES TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_FMTS TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_INSTR_CHOICES TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_INSTRS TO &&role_prefix._USER_ROLE;
GRANT SELECT, INSERT, DELETE ON SIM_IMPORT_DETAILS TO &&role_prefix._USER_ROLE;
GRANT SELECT, INSERT, UPDATE, DELETE ON SIM_IMPORT_LOG TO &&role_prefix._USER_ROLE;
GRANT SELECT, INSERT, DELETE ON SIM_IMP_LINES TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_OCEAN TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_PROJECTS TO &&role_prefix._USER_ROLE;
GRANT SELECT, UPDATE, DELETE ON SIM_RESULTS TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_RESULT_CLASS_INDICATOR TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_RESULT_LAB_REMARKS TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_SAMPLE TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_STATION_LOCATIONS TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_STATION_VISITS TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_STATION_WELLS TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_STATIONS TO &&role_prefix._USER_ROLE;
GRANT SELECT, INSERT, UPDATE, DELETE ON SIM_TRANSLATIONS TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_TRAP_NET TO &&role_prefix._USER_ROLE;
GRANT SELECT, DELETE ON SIM_TRAWL_OPS_DET TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_TRIPS TO &&role_prefix._USER_ROLE;

--Grants to Sequences
GRANT SELECT ON SIM_ACTIVITY_CPORG_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_ACTIVITY_LOC_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_ACTIVITY_PERSONNEL_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_ACTIVITY_PROJECTS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_BRG_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_BRGI_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_COPY_LOG_DETAILS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_COPY_LOG_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_ESTUARY_LOC_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_EXPORT_DETAILS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_EXPORT_LOG_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_FIELD_ACTIVITIES_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_GREAT_LAKE_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_HLP_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_ALLOW_VALUES_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_CFG_DETS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_CFG_INSTRS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_CFG_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_COLS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_DEFS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_FMT_CHOICES_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_FMTS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_INSTR_CHOICES_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_INSTR_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMP_LINES_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMPORT_DETAILS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_IMPORT_LOG_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_OCEAN_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_PROJECTS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_RESULT_CLASS_INDICATOR_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_RESULTS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_SAMPLE_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_STATION_LOCATIONS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_STATION_VISITS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_STATION_WELLS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_STATIONS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_TRANSLATIONS_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_TRAP_NET_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_TRAWL_OPS_DET_SEQ TO &&role_prefix._USER_ROLE;
GRANT SELECT ON SIM_TRIPS_SEQ TO &&role_prefix._USER_ROLE;

--Grants to Packages
GRANT EXECUTE ON SIM_IMPORT_LOCATIONS_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM_IMPORT_WELLS_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM2_EXPORT_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM2_EXPORT_PROJECT_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM2_EXPORT_RESULT_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM2_EXPORT_STATION_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM_EXPORT_LOCATION_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM_EXPORT_WELL_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM2_IMPORT_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM2_IMPORT_PROJECT_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM2_IMPORT_RESULT_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM2_IMPORT_STATION_PKG TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM_IMPORT_RESULT_CHECKS TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM_IMPORT_RESULT_EXTRAS TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM2_COMMIT TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM2_STATION_SORT TO &&role_prefix._USER_ROLE;
GRANT EXECUTE ON SIM_INTERFACE_EXTRAS_PKG TO &&role_prefix._USER_ROLE;
