For Procs

---for procs  
 CREATE PUBLIC SYNONYM  PROC_NAME
   FOR DATABASE_NAME.PROC_NAME;

   GRANT EXECUTE, DEBUG ON PROC_NAME TO ADMIN,ALL_DEVELOPERS;

For Tables

---for tables
CREATE PUBLIC SYNONYM  TABLE_NAME
   FOR TABLE_NAME_SYNONYM;

GRANT INSERT,UPDATE,DELETE,SELECT ON TABLE_NAME TO ADMIN,ALL_DEVELOPERS;

Comments are closed.