Replication Agent for Oracle requires the create any procedure permission to mark procedures for replication.