Who Can Drop a Procedure
The DROP PROCEDURE
statement can be executed by:
-
The owner of the stored procedure
-
Users with the
DROP ANY PROCEDURE
privilege
The DROP PROCEDURE
statement can be executed by:
The owner of the stored procedure
Users with the DROP ANY PROCEDURE
privilege
DROP PROCEDURE
ExampleGET_EMP_PROJ
stored procedure.DROP PROCEDURE GET_EMP_PROJ;