The following is an example of CREATE SYNONYM for Oracle Stored Procedure.
Create Synonym Example For Stored Procedure
For example, you have created a stored procedure named proc_customer, and you want to create a synonym for that. Then your CREATE SYNONYM statement should be as below.
CREATE OR REPLACE SYNONYM syn_proc_customer for proc_customer;
You can give the same name to synonym as procedure’s name.
CREATE OR REPLACE SYNONYM proc_customer for proc_customer;
Grant Permission For Synonym
GRANT EXECUTE ON syn_proc_customer TO SCOTT;