Schema A:
select * from tab;
select * from user_objects where object_type=’PROCEDURE’;
grant execute on GET_SNC_TRNK_BY_SLOT_PORT to impact_user
grant execute on MPLS_1PLUS1 to impact_user;
grant execute on GET_TRUNK_BY_CIRCUIT to impact_user;
grant execute on GET_CIRCUIT_BY_TRUNK to impact_user;
grant execute on GET_DC_NETWORK_DATA to impact_user;
grant select on AUTHORITIES to impact_user ;
grant select on DC_CIRCUIT_PACK to impact_user ;
grant select on DC_CIRCUIT_PACK_ATTRIBUTE to impact_user ;
grant select on DC_NE to impact_user ;
grant select on DC_NETWORKS to impact_user ;
grant select on DC_NETWORK_ATTRIBUTE to impact_user ;
grant select on DC_NE_ATTRIBUTE to impact_user ;
grant select on DC_PORT to impact_user ;
grant select on DC_PORT_ATTRIBUTE to impact_user ;
grant select on DC_RECORD to impact_user ;
grant select on DC_SERVICE to impact_user ;
grant select on DC_SERVICE_ATTRIB to impact_user ;
grant select on DC_SHELF to impact_user ;
grant select on DC_SHELF_ATTRIBUTE to impact_user ;
grant select on DC_SLOT to impact_user ;
grant select on DC_SLOT_ATTRIBUTE to impact_user ;
grant select on PROTECTION_GRPS to impact_user ;
grant select on SC_MODULE_SETTINGS to impact_user ;
grant select on SC_SCHEDULE to impact_user ;
grant select on SC_SEEDS to impact_user ;
grant select on SC_SNMP to impact_user ;
grant select on SNC_CC to impact_user ;
grant select on SNC_TRUNK to impact_user ;
grant select on SNC_TRUNK_ATTR to impact_user ;
grant select on SS_APP to impact_user ;
grant select on SS_MODULE_CONFIG to impact_user ;
grant select on SS_ROLE to impact_user ;
grant select on SS_ROLE_APP to impact_user ;
grant select on SS_USERS_HISTORY to impact_user ;
grant select on USERS to impact_user ;
SCHEMA B:
open sessoin
select * from A.DC_RECORD;
create synonym users for A.USERS
