Hello,

I'm trying to find a way to restrict Oracle to only allow email recipients in one or two specific domains. I have far too many users to build a white list of all email addresses, I'm hoping to be able to restrict by domain: e.g only send to recipients with @example.com addresses?

Running Oracle Database Standard 12.1.0.2 on RHEL 7. I have configured sendmail on the OS to only allow specific domains and that is working for anything sent through the OS, but just had an email sent directly from the database and it was not blocked by the sendmail config.

Can you expand on that at all? Apologies, I am the infrastructure administrator, I deal mostly with the server, Oracle installation, patching, and general config. I don't deal with creating stored procs or much at all inside the database. I ran your reply by my database developer and he isn't sure how that would work either.

UTL_MAIL.SEND (sender=>..., recipients=>..., subject=>..., message=>...);

My_Send (sender=>..., recipients=>..., subject=>..., message=>...);

CREATE OR REPLACE PROCEDRE My_Send (
  SENDER     VARCHAR2,
  RECIPIENTS VARCHAR2,
  SUBJECT    VARCHAR2,
  MESSAGE    VARCHAR2)
IS
BEGIN
  <code to check RECIPIENTS and raise an exception if not correct>
  UTL_MAIL.SEND (sender=>sender, recipients=>recipients, subject=>subject, message=>message);
END;
/