You must have CREATE_PROCEDURE privilege.