revoke create procedure from youruser;

or when privilege is granted via role:
revoke yourrole from youruser;