Rem em_zdt_object_grants_synonyms_loader.sql
Rem
Rem Copyright (c) 2023, 2025, Oracle and/or its affiliates.

Rem BEGIN EMRU_FILE_METADATA
Rem EMRU_SOURCE_FILE:emcore/platformservices/msapp/source/oracle/sysman/emdrep/sql/msapp/24.1.0.0.0/monsvc/em_zdt_object_grants_synonyms_loader.sql
Rem EMRU_UNIX_DELIVERABLES:
Rem emcore/platformservices/msapp/source/oracle/sysman/emdrep/sql/msapp/24.1.0.0.0/monsvc/em_zdt_object_grants_synonyms_loader.sql

Rem EMRU_FILE_POSTINSTALL:<!!! enter the view based location of the executable file. If there is NONE leave as-is !!!>
Rem EMRU_GENERIC_FLAG:NONE
Rem END EMRU_FILE_METADATA

Rem
Rem    NAME
Rem      em_zdt_object_grants_synonyms_loader.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    BEGIN SQL_FILE_METADATA
Rem    SQL_SOURCE_FILE: emcore/platformservices/msapp/source/oracle/sysman/emdrep/sql/msapp/24.1.0.0.0/monsvc/em_zdt_object_grants_synonyms_loader.sql
Rem    SQL_SHIPPED_FILE:
Rem    SQL_PHASE:
Rem    SQL_STARTUP_MODE: NORMAL
Rem    SQL_IGNORABLE_ERRORS: NONE
Rem    END SQL_FILE_METADATA
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem       gbafna   01/15/25 - make synonyms noneditionable
Rem    debasmoh   -07/25/24 - Bug# 36690351: Additional Grants to load data during severity.
Rem    sreddy      05/25/24 - EMCC-149086: Remove grants/synonyms over base tables
Rem    jbacon      11/08/23 - Created
Rem

GRANT ALL ON SYSMAN.DUPTGT_INFO_ARRAY_TYPE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..DUPTGT_INFO_ARRAY_TYPE FOR SYSMAN.DUPTGT_INFO_ARRAY_TYPE;
GRANT ALL ON SYSMAN.EMD_LOADER TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EMD_LOADER FOR SYSMAN.EMD_LOADER;
GRANT ALL ON SYSMAN.EM_AGENT_HEARTBEAT_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_AGENT_HEARTBEAT_ARRAY FOR SYSMAN.EM_AGENT_HEARTBEAT_ARRAY;
GRANT ALL ON SYSMAN.EM_AGENT_HEARTBEAT_RESP_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_AGENT_HEARTBEAT_RESP_ARRAY FOR SYSMAN.EM_AGENT_HEARTBEAT_RESP_ARRAY;
GRANT ALL ON SYSMAN.EM_COLL_UTIL TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_COLL_UTIL FOR SYSMAN.EM_COLL_UTIL;
GRANT ALL ON SYSMAN.MGMT_COLLECTION TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_COLLECTION FOR SYSMAN.MGMT_COLLECTION;
GRANT ALL ON SYSMAN.EM_CURRENT_DEPLOYED_PLUGIN TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_CURRENT_DEPLOYED_PLUGIN FOR SYSMAN.EM_CURRENT_DEPLOYED_PLUGIN;
GRANT ALL ON SYSMAN.EM_CURRENT_METRIC_ERRORS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_CURRENT_METRIC_ERRORS FOR SYSMAN.EM_CURRENT_METRIC_ERRORS;
GRANT ALL ON SYSMAN.EM_CURRENT_VIOLATION TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_CURRENT_VIOLATION FOR SYSMAN.EM_CURRENT_VIOLATION;
GRANT ALL ON SYSMAN.EM_CURRENT_AVAILABILITY TO  &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_CURRENT_AVAILABILITY FOR SYSMAN.EM_CURRENT_AVAILABILITY;
GRANT ALL ON SYSMAN.EM_DEPLOYED_PLUGIN TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_DEPLOYED_PLUGIN FOR SYSMAN.EM_DEPLOYED_PLUGIN;
GRANT ALL ON SYSMAN.EM_FUNCTIONAL_AREAS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_FUNCTIONAL_AREAS FOR SYSMAN.EM_FUNCTIONAL_AREAS;
GRANT ALL ON SYSMAN.EM_GLOBAL_TARGET_PROPERTIES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_GLOBAL_TARGET_PROPERTIES FOR SYSMAN.EM_GLOBAL_TARGET_PROPERTIES;
GRANT ALL ON SYSMAN.EM_JOB_UTIL TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_JOB_UTIL FOR SYSMAN.EM_JOB_UTIL;
GRANT ALL ON SYSMAN.EM_LOADER_TRACE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_LOADER_TRACE FOR SYSMAN.EM_LOADER_TRACE;
GRANT ALL ON SYSMAN.EM_MANAGEABLE_ENTITIES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_MANAGEABLE_ENTITIES FOR SYSMAN.EM_MANAGEABLE_ENTITIES;
GRANT ALL ON SYSMAN.EM_MASTER_AGENT TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_MASTER_AGENT FOR SYSMAN.EM_MASTER_AGENT;
GRANT ALL ON SYSMAN.EM_METRIC TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC FOR SYSMAN.EM_METRIC;
GRANT ALL ON SYSMAN.EM_METRIC_COLUMNS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_COLUMNS FOR SYSMAN.EM_METRIC_COLUMNS;
GRANT ALL ON SYSMAN.EM_METRIC_COLUMN_VER TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_COLUMN_VER FOR SYSMAN.EM_METRIC_COLUMN_VER;
GRANT ALL ON SYSMAN.EM_METRIC_ERRORS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_ERRORS FOR SYSMAN.EM_METRIC_ERRORS;
GRANT ALL ON SYSMAN.EM_METRIC_GROUPS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_GROUPS FOR SYSMAN.EM_METRIC_GROUPS;
GRANT ALL ON SYSMAN.EM_METRIC_GROUP_VER TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_GROUP_VER FOR SYSMAN.EM_METRIC_GROUP_VER;
GRANT ALL ON SYSMAN.EM_METRIC_INTEGER_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_INTEGER_ARRAY FOR SYSMAN.EM_METRIC_INTEGER_ARRAY;
GRANT ALL ON SYSMAN.EM_METRIC_ITEMS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_ITEMS FOR SYSMAN.EM_METRIC_ITEMS;
GRANT ALL ON SYSMAN.EM_METRIC_ITEM_ID_SEQ TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_ITEM_ID_SEQ FOR SYSMAN.EM_METRIC_ITEM_ID_SEQ;
GRANT ALL ON SYSMAN.EM_METRIC_KEYS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_KEYS FOR SYSMAN.EM_METRIC_KEYS;
GRANT ALL ON SYSMAN.EM_METRIC_STRING_HISTORY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_STRING_HISTORY FOR SYSMAN.EM_METRIC_STRING_HISTORY;
GRANT ALL ON SYSMAN.EM_METRIC_STRING_LATEST TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_STRING_LATEST FOR SYSMAN.EM_METRIC_STRING_LATEST;
GRANT ALL ON SYSMAN.EM_METRIC_VALUES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_VALUES FOR SYSMAN.EM_METRIC_VALUES;
GRANT ALL ON SYSMAN.EM_OMS_PROPERTIES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_OMS_PROPERTIES FOR SYSMAN.EM_OMS_PROPERTIES;
GRANT ALL ON SYSMAN.EM_OMS_PROPERTY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_OMS_PROPERTY FOR SYSMAN.EM_OMS_PROPERTY;
GRANT ALL ON SYSMAN.EM_OMS_PROP_CBK TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_OMS_PROP_CBK FOR SYSMAN.EM_OMS_PROP_CBK;
GRANT ALL ON SYSMAN.EM_OMS_PROP_NAME_MAP TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_OMS_PROP_NAME_MAP FOR SYSMAN.EM_OMS_PROP_NAME_MAP;
GRANT ALL ON SYSMAN.EM_PING TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PING FOR SYSMAN.EM_PING;
GRANT ALL ON SYSMAN.EM_PLUGIN TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN FOR SYSMAN.EM_PLUGIN;
GRANT ALL ON SYSMAN.EM_PLUGINCA_CBK_LOG TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGINCA_CBK_LOG FOR SYSMAN.EM_PLUGINCA_CBK_LOG;
GRANT ALL ON SYSMAN.EM_PLUGIN_ARCHIVES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_ARCHIVES FOR SYSMAN.EM_PLUGIN_ARCHIVES;
GRANT ALL ON SYSMAN.EM_PLUGIN_ARTIFACTS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_ARTIFACTS FOR SYSMAN.EM_PLUGIN_ARTIFACTS;
GRANT ALL ON SYSMAN.EM_PLUGIN_CERTIFIED_OS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_CERTIFIED_OS FOR SYSMAN.EM_PLUGIN_CERTIFIED_OS;
GRANT ALL ON SYSMAN.EM_PLUGIN_CERT_PATCH_DETAILS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_CERT_PATCH_DETAILS FOR SYSMAN.EM_PLUGIN_CERT_PATCH_DETAILS;
GRANT ALL ON SYSMAN.EM_PLUGIN_CERT_PATCH_REQ_IF TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_CERT_PATCH_REQ_IF FOR SYSMAN.EM_PLUGIN_CERT_PATCH_REQ_IF;
GRANT ALL ON SYSMAN.EM_PLUGIN_COMP_DEP TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_COMP_DEP FOR SYSMAN.EM_PLUGIN_COMP_DEP;
GRANT ALL ON SYSMAN.EM_PLUGIN_CUSTOM_MODULE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_CUSTOM_MODULE FOR SYSMAN.EM_PLUGIN_CUSTOM_MODULE;
GRANT ALL ON SYSMAN.EM_PLUGIN_DEPENDENCY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_DEPENDENCY FOR SYSMAN.EM_PLUGIN_DEPENDENCY;
GRANT ALL ON SYSMAN.EM_PLUGIN_DEPLOY_BAK_INFO TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_DEPLOY_BAK_INFO FOR SYSMAN.EM_PLUGIN_DEPLOY_BAK_INFO;
GRANT ALL ON SYSMAN.EM_PLUGIN_DEPLOY_DETAIL TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_DEPLOY_DETAIL FOR SYSMAN.EM_PLUGIN_DEPLOY_DETAIL;
GRANT ALL ON SYSMAN.EM_PLUGIN_DEPLOY_INSTANCE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_DEPLOY_INSTANCE FOR SYSMAN.EM_PLUGIN_DEPLOY_INSTANCE;
GRANT ALL ON SYSMAN.EM_PLUGIN_DEPLOY_INSTANCE_DATA TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_DEPLOY_INSTANCE_DATA FOR SYSMAN.EM_PLUGIN_DEPLOY_INSTANCE_DATA;
GRANT ALL ON SYSMAN.EM_PLUGIN_DEPLOY_STEP_STATUS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_DEPLOY_STEP_STATUS FOR SYSMAN.EM_PLUGIN_DEPLOY_STEP_STATUS;
GRANT ALL ON SYSMAN.EM_PLUGIN_DEPLOY_SUMMARY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_DEPLOY_SUMMARY FOR SYSMAN.EM_PLUGIN_DEPLOY_SUMMARY;
GRANT ALL ON SYSMAN.EM_PLUGIN_DEPRECATION_INFO TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_DEPRECATION_INFO FOR SYSMAN.EM_PLUGIN_DEPRECATION_INFO;
GRANT ALL ON SYSMAN.EM_PLUGIN_DEP_PREREQ TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_DEP_PREREQ FOR SYSMAN.EM_PLUGIN_DEP_PREREQ;
GRANT ALL ON SYSMAN.EM_PLUGIN_EXT_ARTIFACTS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_EXT_ARTIFACTS FOR SYSMAN.EM_PLUGIN_EXT_ARTIFACTS;
GRANT ALL ON SYSMAN.EM_PLUGIN_LIFECYCLE_CBK TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_LIFECYCLE_CBK FOR SYSMAN.EM_PLUGIN_LIFECYCLE_CBK;
GRANT ALL ON SYSMAN.EM_PLUGIN_LOCK_TRACK TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_LOCK_TRACK FOR SYSMAN.EM_PLUGIN_LOCK_TRACK;
GRANT ALL ON SYSMAN.EM_PLUGIN_MIN_VERSION_SUPPORT TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_MIN_VERSION_SUPPORT FOR SYSMAN.EM_PLUGIN_MIN_VERSION_SUPPORT;
GRANT ALL ON SYSMAN.EM_PLUGIN_MISC_INFO TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_MISC_INFO FOR SYSMAN.EM_PLUGIN_MISC_INFO;
GRANT ALL ON SYSMAN.EM_PLUGIN_RELOCATE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_RELOCATE FOR SYSMAN.EM_PLUGIN_RELOCATE;
GRANT ALL ON SYSMAN.EM_PLUGIN_REPOS_COMPONENT TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_REPOS_COMPONENT FOR SYSMAN.EM_PLUGIN_REPOS_COMPONENT;
GRANT ALL ON SYSMAN.EM_PLUGIN_TGT_TYPE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_TGT_TYPE FOR SYSMAN.EM_PLUGIN_TGT_TYPE;
GRANT ALL ON SYSMAN.EM_PLUGIN_TGT_TYPE_VERSION TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_TGT_TYPE_VERSION FOR SYSMAN.EM_PLUGIN_TGT_TYPE_VERSION;
GRANT ALL ON SYSMAN.EM_PLUGIN_VERSION TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_PLUGIN_VERSION FOR SYSMAN.EM_PLUGIN_VERSION;
GRANT ALL ON SYSMAN.EM_POLICY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_POLICY FOR SYSMAN.EM_POLICY;
GRANT ALL ON SYSMAN.EM_SEC TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_SEC FOR SYSMAN.EM_SEC;
GRANT ALL ON SYSMAN.EM_SEVERITY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_SEVERITY FOR SYSMAN.EM_SEVERITY;
GRANT ALL ON SYSMAN.EM_TARGET TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_TARGET FOR SYSMAN.EM_TARGET;
GRANT ALL ON SYSMAN.EM_USER_MODEL TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_USER_MODEL FOR SYSMAN.EM_USER_MODEL;
GRANT ALL ON SYSMAN.EM_VIOLATIONS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_VIOLATIONS FOR SYSMAN.EM_VIOLATIONS;
GRANT ALL ON SYSMAN.GC$BLACKOUT_OBJ TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..GC$BLACKOUT_OBJ FOR SYSMAN.GC$BLACKOUT_OBJ;
GRANT ALL ON SYSMAN.GC$BLACKOUT_SCHEDULE_OBJ TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..GC$BLACKOUT_SCHEDULE_OBJ FOR SYSMAN.GC$BLACKOUT_SCHEDULE_OBJ;
GRANT ALL ON SYSMAN.GC$BLACKOUT_TARGET_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..GC$BLACKOUT_TARGET_ARRAY FOR SYSMAN.GC$BLACKOUT_TARGET_ARRAY;
GRANT ALL ON SYSMAN.GC$OBJ_LOG TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..GC$OBJ_LOG FOR SYSMAN.GC$OBJ_LOG;
GRANT ALL ON SYSMAN.GC_EVENT_RECEIVER TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..GC_EVENT_RECEIVER FOR SYSMAN.GC_EVENT_RECEIVER;
GRANT ALL ON SYSMAN.GC_LIFECYCLE_STATES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..GC_LIFECYCLE_STATES FOR SYSMAN.GC_LIFECYCLE_STATES;
GRANT ALL ON SYSMAN.MGMT_ADMIN_DATA TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_ADMIN_DATA FOR SYSMAN.MGMT_ADMIN_DATA;
GRANT ALL ON SYSMAN.MGMT_ADMIN_MSG_LIST TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_ADMIN_MSG_LIST FOR SYSMAN.MGMT_ADMIN_MSG_LIST;
GRANT ALL ON SYSMAN.MGMT_AVAIL TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_AVAIL FOR SYSMAN.MGMT_AVAIL;
GRANT ALL ON SYSMAN.MGMT_BLACKOUT_ENGINE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_BLACKOUT_ENGINE FOR SYSMAN.MGMT_BLACKOUT_ENGINE;
GRANT ALL ON SYSMAN.MGMT_BLACKOUT_ENGINE_NG TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_BLACKOUT_ENGINE_NG FOR SYSMAN.MGMT_BLACKOUT_ENGINE_NG;
GRANT ALL ON SYSMAN.MGMT_DUPLICATE_TARGETS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_DUPLICATE_TARGETS FOR SYSMAN.MGMT_DUPLICATE_TARGETS;
GRANT ALL ON SYSMAN.MGMT_EMD_PING TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_EMD_PING FOR SYSMAN.MGMT_EMD_PING;
GRANT ALL ON SYSMAN.MGMT_EV_CHANGE_SEQ TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_EV_CHANGE_SEQ FOR SYSMAN.MGMT_EV_CHANGE_SEQ;
GRANT ALL ON SYSMAN.MGMT_GENSVC_AVAIL TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_GENSVC_AVAIL FOR SYSMAN.MGMT_GENSVC_AVAIL;
GRANT ALL ON SYSMAN.MGMT_GLOBAL TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_GLOBAL FOR SYSMAN.MGMT_GLOBAL;
GRANT ALL ON SYSMAN.MGMT_JOB_ENGINE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_JOB_ENGINE FOR SYSMAN.MGMT_JOB_ENGINE;
GRANT ALL ON SYSMAN.MGMT_JOB_SCHEDULE_RECORD TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_JOB_SCHEDULE_RECORD FOR SYSMAN.MGMT_JOB_SCHEDULE_RECORD;
GRANT ALL ON SYSMAN.MGMT_LOAD_ENTRIES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_LOAD_ENTRIES FOR SYSMAN.MGMT_LOAD_ENTRIES;
GRANT ALL ON SYSMAN.MGMT_LOCK_UTIL TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_LOCK_UTIL FOR SYSMAN.MGMT_LOCK_UTIL;
GRANT ALL ON SYSMAN.MGMT_LOG TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_LOG FOR SYSMAN.MGMT_LOG;
GRANT ALL ON SYSMAN.MGMT_LONG_TEXT TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_LONG_TEXT FOR SYSMAN.MGMT_LONG_TEXT;
GRANT ALL ON SYSMAN.MGMT_METRIC TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_METRIC FOR SYSMAN.MGMT_METRIC;
GRANT ALL ON SYSMAN.MGMT_METRIC_ERRORS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_METRIC_ERRORS FOR SYSMAN.MGMT_METRIC_ERRORS;
GRANT ALL ON SYSMAN.MGMT_OMS_PARAMETERS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_OMS_PARAMETERS FOR SYSMAN.MGMT_OMS_PARAMETERS;
GRANT ALL ON SYSMAN.MGMT_OMS_PROPERTY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_OMS_PROPERTY FOR SYSMAN.MGMT_OMS_PROPERTY;
GRANT ALL ON SYSMAN.MGMT_OMS_PROPERTY_DEF TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_OMS_PROPERTY_DEF FOR SYSMAN.MGMT_OMS_PROPERTY_DEF;
GRANT ALL ON SYSMAN.MGMT_OMS_PROPERTY_ENUM TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_OMS_PROPERTY_ENUM FOR SYSMAN.MGMT_OMS_PROPERTY_ENUM;
GRANT ALL ON SYSMAN.MGMT_POLICIES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_POLICIES FOR SYSMAN.MGMT_POLICIES;
GRANT ALL ON SYSMAN.MGMT_POLICY_ASSOC_CFG TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_POLICY_ASSOC_CFG FOR SYSMAN.MGMT_POLICY_ASSOC_CFG;
GRANT ALL ON SYSMAN.MGMT_POLICY_ASSOC TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_POLICY_ASSOC FOR SYSMAN.MGMT_POLICY_ASSOC;
GRANT ALL ON SYSMAN.MGMT_PRIVS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_PRIVS FOR SYSMAN.MGMT_PRIVS;
GRANT ALL ON SYSMAN.MGMT_REPOS_TIME_COEFFICIENT TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_REPOS_TIME_COEFFICIENT FOR SYSMAN.MGMT_REPOS_TIME_COEFFICIENT;
GRANT ALL ON SYSMAN.MGMT_SECURITY_CLASSES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_SECURITY_CLASSES FOR SYSMAN.MGMT_SECURITY_CLASSES;
GRANT ALL ON SYSMAN.MGMT_TARGETS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TARGETS FOR SYSMAN.MGMT_TARGETS;
GRANT ALL ON SYSMAN.MGMT_TARGETS_DELETE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TARGETS_DELETE FOR SYSMAN.MGMT_TARGETS_DELETE;
GRANT ALL ON SYSMAN.MGMT_TARGET_AGENT_ASSOC TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TARGET_AGENT_ASSOC FOR SYSMAN.MGMT_TARGET_AGENT_ASSOC;
GRANT ALL ON SYSMAN.MGMT_TIME_SYNC TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TIME_SYNC FOR SYSMAN.MGMT_TIME_SYNC;
GRANT ALL ON SYSMAN.MGMT_USER TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_USER FOR SYSMAN.MGMT_USER;
GRANT ALL ON SYSMAN.MGMT_VERSIONS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_VERSIONS FOR SYSMAN.MGMT_VERSIONS;
GRANT ALL ON SYSMAN.MGMT_VIOLATION_CONTEXT TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_VIOLATION_CONTEXT FOR SYSMAN.MGMT_VIOLATION_CONTEXT;
GRANT ALL ON SYSMAN.MGMT_VIOLATION_SUMMARY_REC TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_VIOLATION_SUMMARY_REC FOR SYSMAN.MGMT_VIOLATION_SUMMARY_REC;
GRANT ALL ON SYSMAN.SETEMUSERCONTEXT TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..SETEMUSERCONTEXT FOR SYSMAN.SETEMUSERCONTEXT;
GRANT ALL ON SYSMAN.SMP_EMD_STRING_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..SMP_EMD_STRING_ARRAY FOR SYSMAN.SMP_EMD_STRING_ARRAY;
GRANT ALL ON SYSMAN.STORAGE_ECM_PKG TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..STORAGE_ECM_PKG FOR SYSMAN.STORAGE_ECM_PKG;
GRANT ALL ON SYSMAN_TYPES.EM_METRIC_VALUE_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE NONEDITIONABLE SYNONYM &&EM_ZDT_USER..EM_METRIC_VALUE_ARRAY FOR SYSMAN_TYPES.EM_METRIC_VALUE_ARRAY;

GRANT ALL ON SYSMAN.EM_LOOKUP_ATTRIBUTES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_LOOKUP_ATTRIBUTES FOR SYSMAN.EM_LOOKUP_ATTRIBUTES;
GRANT ALL ON SYSMAN.EM_LOOKUP_ATTRIBUTE_SETS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_LOOKUP_ATTRIBUTE_SETS FOR SYSMAN.EM_LOOKUP_ATTRIBUTE_SETS;
GRANT ALL ON SYSMAN.MGMT_METRIC_VERSIONS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_METRIC_VERSIONS FOR SYSMAN.MGMT_METRIC_VERSIONS;
GRANT ALL ON SYSMAN.MGMT_COLL_ITEMS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_COLL_ITEMS FOR SYSMAN.MGMT_COLL_ITEMS;
GRANT ALL ON SYSMAN.MGMT_COLL_ITEM_METRICS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_COLL_ITEM_METRICS FOR SYSMAN.MGMT_COLL_ITEM_METRICS;
GRANT ALL ON SYSMAN.MGMT_COLLECTIONS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_COLLECTIONS FOR SYSMAN.MGMT_COLLECTIONS;
GRANT ALL ON SYSMAN.MGMT_COLL_ITEM_PROPERTIES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_COLL_ITEM_PROPERTIES FOR SYSMAN.MGMT_COLL_ITEM_PROPERTIES;
GRANT ALL ON SYSMAN.MGMT_COLL_TRIGGERS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_COLL_TRIGGERS FOR SYSMAN.MGMT_COLL_TRIGGERS;
GRANT ALL ON SYSMAN.EM_MS_REVERSE_PINGS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_MS_REVERSE_PINGS FOR SYSMAN.EM_MS_REVERSE_PINGS;
GRANT ALL ON SYSMAN.EM_ASSOC TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_ASSOC FOR SYSMAN.EM_ASSOC;
GRANT ALL ON SYSMAN.EM_METRIC_VALUE_ARRAY_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_VALUE_ARRAY_ARRAY FOR SYSMAN.EM_METRIC_VALUE_ARRAY_ARRAY;

GRANT ALL ON SYSMAN.EM_METRIC_INTEGER_ARRAY_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_INTEGER_ARRAY_ARRAY FOR SYSMAN.EM_METRIC_INTEGER_ARRAY_ARRAY;
GRANT ALL ON SYSMAN.EM_METRIC_KEY_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_KEY_ARRAY FOR SYSMAN.EM_METRIC_KEY_ARRAY;
GRANT ALL ON SYSMAN.EM_METRIC_KEY_ARRAY_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_KEY_ARRAY_ARRAY FOR SYSMAN.EM_METRIC_KEY_ARRAY_ARRAY;
GRANT ALL ON SYSMAN.EM_METRIC_STRING_ARRAY_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_STRING_ARRAY_ARRAY FOR SYSMAN.EM_METRIC_STRING_ARRAY_ARRAY;
GRANT ALL ON SYSMAN.EM_METRIC_STRING_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_STRING_ARRAY FOR SYSMAN.EM_METRIC_STRING_ARRAY;

GRANT ALL ON SYSMAN.GC$ECM_CONFIG_HISTORY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..GC$ECM_CONFIG_HISTORY FOR SYSMAN.GC$ECM_CONFIG_HISTORY;
GRANT ALL ON SYSMAN.MGMT_PLUGIN_MISMATCH TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_PLUGIN_MISMATCH FOR SYSMAN.MGMT_PLUGIN_MISMATCH;
GRANT ALL ON SYSMAN.MGMT_JOB_VECTOR_PARAMS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_JOB_VECTOR_PARAMS FOR SYSMAN.MGMT_JOB_VECTOR_PARAMS;
GRANT ALL ON SYSMAN.EM_LOADER_AGENT_CACHE_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_LOADER_AGENT_CACHE_ARRAY FOR SYSMAN.EM_LOADER_AGENT_CACHE_ARRAY;
GRANT ALL ON SYSMAN.MGMT_SQLTRACE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_SQLTRACE FOR SYSMAN.MGMT_SQLTRACE;
GRANT ALL ON SYSMAN.MGMT_TARGET_OBJ TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TARGET_OBJ FOR SYSMAN.MGMT_TARGET_OBJ;
GRANT ALL ON SYSMAN.MGMT_TARGET_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TARGET_ARRAY FOR SYSMAN.MGMT_TARGET_ARRAY;
GRANT ALL ON SYSMAN.EM_MANAGEABLE_ENTITY_OBJ TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_MANAGEABLE_ENTITY_OBJ FOR SYSMAN.EM_MANAGEABLE_ENTITY_OBJ;
GRANT ALL ON SYSMAN.EM_MANAGEABLE_ENTITY_OBJ_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_MANAGEABLE_ENTITY_OBJ_ARRAY FOR SYSMAN.EM_MANAGEABLE_ENTITY_OBJ_ARRAY;
GRANT ALL ON SYSMAN.EM_TARGETS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_TARGETS FOR SYSMAN.EM_TARGETS;
GRANT ALL ON SYSMAN.EM_TARGET_TYPES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_TARGET_TYPES FOR SYSMAN.EM_TARGET_TYPES;
GRANT ALL ON SYSMAN.GC_CURRENT_DEPLOYED_PLUGIN TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..GC_CURRENT_DEPLOYED_PLUGIN FOR SYSMAN.GC_CURRENT_DEPLOYED_PLUGIN;
GRANT ALL ON SYSMAN.EM_ENTITY_PROPERTIES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_ENTITY_PROPERTIES FOR SYSMAN.EM_ENTITY_PROPERTIES;
GRANT ALL ON SYSMAN.EM_TARGET_AP_CURRENT_CAP_MAP TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_TARGET_AP_CURRENT_CAP_MAP FOR SYSMAN.EM_TARGET_AP_CURRENT_CAP_MAP;
GRANT ALL ON SYSMAN.EM_TARGET_AP_CAP_BEST_IMP TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_TARGET_AP_CAP_BEST_IMP FOR SYSMAN.EM_TARGET_AP_CAP_BEST_IMP;
GRANT ALL ON SYSMAN.MGMT_TARGET_TYPE_EXTENDS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TARGET_TYPE_EXTENDS FOR SYSMAN.MGMT_TARGET_TYPE_EXTENDS;
GRANT ALL ON SYSMAN_TYPES.MGMT_SHORT_STRING_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE NONEDITIONABLE SYNONYM &&EM_ZDT_USER..MGMT_SHORT_STRING_ARRAY FOR SYSMAN_TYPES.MGMT_SHORT_STRING_ARRAY;
GRANT ALL ON SYSMAN.MGMT_ASSOC_TYPE_EXTENDS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_ASSOC_TYPE_EXTENDS FOR SYSMAN.MGMT_ASSOC_TYPE_EXTENDS;
GRANT ALL ON SYSMAN.MGMT_ASSOC_TYPE_ALLOWED_PAIRS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_ASSOC_TYPE_ALLOWED_PAIRS FOR SYSMAN.MGMT_ASSOC_TYPE_ALLOWED_PAIRS;
GRANT ALL ON SYSMAN.MGMT_TYPE_PROPERTIES TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TYPE_PROPERTIES FOR SYSMAN.MGMT_TYPE_PROPERTIES;
GRANT ALL ON SYSMAN.EM_TARGET_LOOKUP TO &&EM_ZDT_USER; 
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_TARGET_LOOKUP FOR SYSMAN.EM_TARGET_LOOKUP;
GRANT ALL ON SYSMAN_TYPES.MGMT_LONG_STRING_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE NONEDITIONABLE SYNONYM &&EM_ZDT_USER..MGMT_LONG_STRING_ARRAY FOR SYSMAN_TYPES.MGMT_LONG_STRING_ARRAY;
GRANT ALL ON SYSMAN.MGMT_TARGET_PROPERTY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TARGET_PROPERTY FOR SYSMAN.MGMT_TARGET_PROPERTY;
GRANT ALL ON SYSMAN.MGMT_TARGET_PROPERTY_LIST TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TARGET_PROPERTY_LIST FOR SYSMAN.MGMT_TARGET_PROPERTY_LIST;
GRANT ALL ON SYSMAN_TYPES.MGMT_SHORT_STRING_TABLE TO &&EM_ZDT_USER;
CREATE OR REPLACE NONEDITIONABLE SYNONYM &&EM_ZDT_USER..MGMT_SHORT_STRING_TABLE FOR SYSMAN_TYPES.MGMT_SHORT_STRING_TABLE;
GRANT ALL ON SYSMAN.GC_TARGET_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..GC_TARGET_ARRAY FOR SYSMAN.GC_TARGET_ARRAY;
GRANT ALL ON SYSMAN.EM_TARGET_ERROR_OBJ TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_TARGET_ERROR_OBJ FOR SYSMAN.EM_TARGET_ERROR_OBJ;
GRANT ALL ON SYSMAN.MGMT_GUID_PAIR_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_GUID_PAIR_ARRAY FOR SYSMAN.MGMT_GUID_PAIR_ARRAY;
GRANT ALL ON SYSMAN.MGMT_INTEGER_TABLE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_INTEGER_TABLE FOR SYSMAN.MGMT_INTEGER_TABLE;
GRANT ALL ON SYSMAN.MGMT_MAX_STRING_TABLE TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_MAX_STRING_TABLE FOR SYSMAN.MGMT_MAX_STRING_TABLE;
GRANT ALL ON SYSMAN_TYPES.SMP_EMD_NVPAIR TO &&EM_ZDT_USER;
CREATE OR REPLACE NONEDITIONABLE SYNONYM &&EM_ZDT_USER..SMP_EMD_NVPAIR FOR SYSMAN_TYPES.SMP_EMD_NVPAIR;
GRANT ALL ON SYSMAN.EM_CAPABILITY_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_CAPABILITY_ARRAY FOR SYSMAN.EM_CAPABILITY_ARRAY;
GRANT ALL ON SYSMAN.MGMT_TARGET_PROP_DEFS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TARGET_PROP_DEFS FOR SYSMAN.MGMT_TARGET_PROP_DEFS;
GRANT ALL ON SYSMAN.MGMT_ID_ATTRS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_ID_ATTRS FOR SYSMAN.MGMT_ID_ATTRS;
GRANT ALL ON SYSMAN.MGMT_ID_ATTRS_LIST TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_ID_ATTRS_LIST FOR SYSMAN.MGMT_ID_ATTRS_LIST;
GRANT ALL ON SYSMAN.MGMT_ASSOC_INST_OBJ TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_ASSOC_INST_OBJ FOR SYSMAN.MGMT_ASSOC_INST_OBJ;
GRANT ALL ON SYSMAN.MGMT_ASSOC_INST_LIST TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_ASSOC_INST_LIST FOR SYSMAN.MGMT_ASSOC_INST_LIST;
GRANT ALL ON SYSMAN.MGMT_ASSOC_INST_PROP_OBJ TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_ASSOC_INST_PROP_OBJ FOR SYSMAN.MGMT_ASSOC_INST_PROP_OBJ;
GRANT ALL ON SYSMAN.MGMT_ASSOC_INST_PROP_LIST TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_ASSOC_INST_PROP_LIST FOR SYSMAN.MGMT_ASSOC_INST_PROP_LIST;
GRANT ALL ON SYSMAN.MGMT_ASSOC_NG to &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_ASSOC_NG FOR SYSMAN.MGMT_ASSOC_NG;
GRANT ALL ON SYSMAN.MGMT_TARGET_GUID_ARRAY TO &&EM_ZDT_USER;   
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TARGET_GUID_ARRAY FOR SYSMAN.MGMT_TARGET_GUID_ARRAY;
GRANT ALL ON SYSMAN.EMDW_LOG TO &&EM_ZDT_USER;   
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EMDW_LOG FOR SYSMAN.EMDW_LOG;
GRANT ALL ON SYSMAN.MGMT_TARGET TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..MGMT_TARGET FOR SYSMAN.MGMT_TARGET;   
GRANT ALL ON SYSMAN.EM_METRIC_ERROR_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_ERROR_ARRAY FOR SYSMAN.EM_METRIC_ERROR_ARRAY;
GRANT ALL ON SYSMAN.EM_METRIC_VALUE_ARRAY_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_VALUE_ARRAY_ARRAY FOR SYSMAN.EM_METRIC_VALUE_ARRAY_ARRAY;
GRANT ALL ON SYSMAN.EM_METRIC_STRING_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_STRING_ARRAY FOR SYSMAN.EM_METRIC_STRING_ARRAY;
GRANT ALL ON SYSMAN.EM_METRIC_STRING_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_STRING_ARRAY_ARRAY FOR SYSMAN.EM_METRIC_STRING_ARRAY_ARRAY;
GRANT ALL ON SYSMAN.EM_LOADER_UPLOAD_TIME TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_LOADER_UPLOAD_TIME FOR SYSMAN.EM_LOADER_UPLOAD_TIME;
GRANT ALL ON SYSMAN.EM_LOADER_UPLOAD_TIME_ARRAY TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_LOADER_UPLOAD_TIME_ARRAY FOR SYSMAN.EM_LOADER_UPLOAD_TIME_ARRAY;
GRANT ALL ON SYSMAN.EM_TARGET_COLLECTION_STATS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_TARGET_COLLECTION_STATS FOR SYSMAN.EM_TARGET_COLLECTION_STATS;
GRANT ALL ON SYSMAN.EM_METRIC_COLLECTION_STATS TO &&EM_ZDT_USER;
CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..EM_METRIC_COLLECTION_STATS FOR SYSMAN.EM_METRIC_COLLECTION_STATS; 
   

--
-- Grant access to all object starting with EM_PLUGIN
--
begin
  for sysman_objs  in (
    select * from dba_objects where object_name like 'EM_PLUGIN%' and owner = 'SYSMAN' and
                   object_type in ('VIEW', 'PACKAGE', 'FUNCTION', 'TYPE')
  ) LOOP
    begin
     execute immediate 'GRANT ALL ON ' ||
         'SYSMAN.' || sysman_objs.object_name || ' TO &&EM_ZDT_USER ';
     execute immediate 'CREATE OR REPLACE SYNONYM &&EM_ZDT_USER..' ||  sysman_objs.object_name ||
         ' FOR SYSMAN.' || sysman_objs.object_name;
    exception when others then
      dbms_output.put_line(sqlerrm);
    end;
  END LOOP;
end;
/






