Privileges for creation and execution of procedures

To create a procedure in current user schema we use the syntax

CREATE OR REPLACE PROCEDURE (<argslist) IS
-------
-------

To create procedure in any schema we use

CREATE OR REPLACE ANY PROCEDURE (<argslist) IS
-------
-------

To grant EXECUTE privilege to some user on a procedure we write

GRANT EXECUTE ON <procedure-name> TO <user-name>

SQL> SELECT * FROM USER_PROCEDURES;
Lists all the procedures, functions in current user.

SQL> SELECT * FROM USER_PROCEDURES;
Lists all the procedures, functions in all users.

SQL> DROP PROCEDURE <procedure-name> ;
Drops or Removes a procedure from database

SQL> DROP FUNCTION <function-name> ; 
Drops or Removes a function from database