
--Drop Synonyms for objects granted to SIMxx_USER_ROLE
set verify off
DEFINE objowner = STORUSER

--Table Synonyms
Drop synonym &&objowner..SIM_ACTIVITY_CPORG;
Drop synonym &&objowner..SIM_ACTIVITY_PERSONNEL;
Drop synonym &&objowner..SIM_ACTIVITY_PROJECTS;
Drop synonym &&objowner..SIM_ACTUAL_ACTIVITY_LOC;
Drop synonym &&objowner..SIM_BIO_RESULTS_GRP;
Drop synonym &&objowner..SIM_BIO_RESULTS_GRP_INDIVIDUAL;
Drop synonym &&objowner..SIM_CONFIG;
Drop synonym &&objowner..SIM_COPY_LOG;
Drop synonym &&objowner..SIM_COPY_LOG_DETAILS;
Drop synonym &&objowner..SIM_ESTUARY_LOC;
Drop synonym &&objowner..SIM_EXPORT_DETAILS;
Drop synonym &&objowner..SIM_EXPORT_LOG;
Drop synonym &&objowner..SIM_FIELD_ACTIVITIES;
Drop synonym &&objowner..SIM_FIELD_ACTIVITY_PARENT;
Drop synonym &&objowner..SIM_GREAT_LAKE;
Drop synonym &&objowner..SIM_HELP;
Drop synonym &&objowner..SIM_IMP_ALLOW_VALUES;
Drop synonym &&objowner..SIM_IMP_CFG;
Drop synonym &&objowner..SIM_IMP_CFG_DETS;
Drop synonym &&objowner..SIM_IMP_CFG_INSTRS;
Drop synonym &&objowner..SIM_IMP_COLS;
Drop synonym &&objowner..SIM_IMP_DEFS;
Drop synonym &&objowner..SIM_IMP_FMT_CHOICES;
Drop synonym &&objowner..SIM_IMP_FMTS;
Drop synonym &&objowner..SIM_IMP_INSTR_CHOICES;
Drop synonym &&objowner..SIM_IMP_INSTRS;
Drop synonym &&objowner..SIM_IMP_LINES;
Drop synonym &&objowner..SIM_IMPORT_DETAILS;
Drop synonym &&objowner..SIM_IMPORT_LOG;
Drop synonym &&objowner..SIM_OCEAN;
Drop synonym &&objowner..SIM_PROJECTS;
Drop synonym &&objowner..SIM_RESULTS;
Drop synonym &&objowner..SIM_RESULT_CLASS_INDICATOR;
Drop synonym &&objowner..SIM_RESULT_LAB_REMARKS;
Drop synonym &&objowner..SIM_SAMPLE;
Drop synonym &&objowner..SIM_STATION_LOCATIONS;
Drop synonym &&objowner..SIM_STATION_VISITS;
Drop synonym &&objowner..SIM_STATION_WELLS;
Drop synonym &&objowner..SIM_STATIONS;
Drop synonym &&objowner..SIM_TRANSLATIONS;
Drop synonym &&objowner..SIM_TRAP_NET;
Drop synonym &&objowner..SIM_TRAWL_OPS_DET;
Drop synonym &&objowner..SIM_TRIPS;
Drop synonym &&objowner..SIM_WEB_FILES;
Drop synonym &&objowner..SIM_WEB_SELECTED_VALUES;

--Sequence Synonyms
Drop synonym &&objowner..SIM_ACTIVITY_CPORG_SEQ;
Drop synonym &&objowner..SIM_ACTIVITY_LOC_SEQ;
Drop synonym &&objowner..SIM_ACTIVITY_PERSONNEL_SEQ;
Drop synonym &&objowner..SIM_ACTIVITY_PROJECTS_SEQ;
Drop synonym &&objowner..SIM_BRG_SEQ;
Drop synonym &&objowner..SIM_BRGI_SEQ;
Drop synonym &&objowner..SIM_COPY_LOG_DETAILS_SEQ;
Drop synonym &&objowner..SIM_COPY_LOG_SEQ;
Drop synonym &&objowner..SIM_ESTUARY_LOC_SEQ;
Drop synonym &&objowner..SIM_EXPORT_DETAILS_SEQ;
Drop synonym &&objowner..SIM_EXPORT_LOG_SEQ;
Drop synonym &&objowner..SIM_FIELD_ACTIVITIES_SEQ;
Drop synonym &&objowner..SIM_FIELD_ACTIVITY_PARENT_SEQ;
Drop synonym &&objowner..SIM_GREAT_LAKE_SEQ;
Drop synonym &&objowner..SIM_HLP_SEQ;
Drop synonym &&objowner..SIM_IMP_ALLOW_VALUES_SEQ;
Drop synonym &&objowner..SIM_IMP_CFG_DETS_SEQ;
Drop synonym &&objowner..SIM_IMP_CFG_INSTRS_SEQ;
Drop synonym &&objowner..SIM_IMP_CFG_SEQ;
Drop synonym &&objowner..SIM_IMP_COLS_SEQ;
Drop synonym &&objowner..SIM_IMP_DEFS_SEQ;
Drop synonym &&objowner..SIM_IMP_FMT_CHOICES_SEQ;
Drop synonym &&objowner..SIM_IMP_FMTS_SEQ;
Drop synonym &&objowner..SIM_IMP_INSTR_CHOICES_SEQ;
Drop synonym &&objowner..SIM_IMP_INSTR_SEQ;
Drop synonym &&objowner..SIM_IMP_LINES_SEQ;
Drop synonym &&objowner..SIM_IMPORT_DETAILS_SEQ;
Drop synonym &&objowner..SIM_IMPORT_LOG_SEQ;
Drop synonym &&objowner..SIM_OCEAN_SEQ;
Drop synonym &&objowner..SIM_PROJECTS_SEQ;
Drop synonym &&objowner..SIM_RESULT_CLASS_INDICATOR_SEQ;
Drop synonym &&objowner..SIM_RESULTS_SEQ;
Drop synonym &&objowner..SIM_SRLR_SEQ;
Drop synonym &&objowner..SIM_SAMPLE_SEQ;
Drop synonym &&objowner..SIM_STATION_LOCATIONS_SEQ;
Drop synonym &&objowner..SIM_STATION_VISITS_SEQ;
Drop synonym &&objowner..SIM_STATION_WELLS_SEQ;
Drop synonym &&objowner..SIM_STATIONS_SEQ;
Drop synonym &&objowner..SIM_TRANSLATIONS_SEQ;
Drop synonym &&objowner..SIM_TRAP_NET_SEQ;
Drop synonym &&objowner..SIM_TRAWL_OPS_DET_SEQ;
Drop synonym &&objowner..SIM_TRIPS_SEQ;
Drop synonym &&objowner..SIM_WEB_FILES_SEQ;

--Package Synonyms
Drop synonym &&objowner..SIM_IMPORT_LOCATIONS_PKG;
Drop synonym &&objowner..SIM_IMPORT_WELLS_PKG;
Drop synonym &&objowner..SIM2_EXPORT_PKG;
Drop synonym &&objowner..SIM2_EXPORT_PROJECT_PKG;
Drop synonym &&objowner..SIM2_EXPORT_RESULT_PKG;
Drop synonym &&objowner..SIM2_EXPORT_STATION_PKG;
Drop synonym &&objowner..SIM_EXPORT_LOCATION_PKG;
Drop synonym &&objowner..SIM_EXPORT_WELL_PKG;
Drop synonym &&objowner..SIM2_IMPORT_PKG;
Drop synonym &&objowner..SIM2_IMPORT_PROJECT_PKG;
Drop synonym &&objowner..SIM2_IMPORT_RESULT_PKG;
Drop synonym &&objowner..SIM2_IMPORT_STATION_PKG;
Drop synonym &&objowner..SIM_IMPORT_RESULT_CHECKS;
Drop synonym &&objowner..SIM_IMPORT_RESULT_EXTRAS;
Drop synonym &&objowner..SIM2_COMMIT;
Drop synonym &&objowner..SIM2_STATION_SORT;
Drop synonym &&objowner..SIM_INTERFACE_EXTRAS_PKG;

EXIT