GRANT CREATE PROCEDURE TO USER_NAME;
GRANT CREATE ANY PROCEDURE TO USER_NAME;
GRANT ALTER ANY PROCEDURE TO USER_NAME;
GRANT DROP ANY PROCEDURE TO USER_NAME;
GRANT EXECUTE ANY PROCEDURE TO USER_NAME;
GRANT DEBUG ANY PROCEDURE TO USER_NAME;
commit;

create or replace procedure temp_procd
as
V_TOTAL NUMBER(10);
begin 
dbms_output.put_line('test create procedure');
end;

drop PROCEDURE temp_procd;