Home » SQL » Create Synonym for Stored Procedure in Oracle

Create Synonym for Stored Procedure in Oracle

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;

See also: