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;