on sqlplus

select * from dba_tab_privs where table_name = 'UTL_SMTP';

select grantee , table_name , privilege from dba_tab_privs where table_name = 'UTL_HTTP';

select acl , host , lower_port , upper_port from DBA_NETWORK_ACLS;

select acl , principal , privilege , is_grant from DBA_NETWORK_ACL_PRIVILEGES;

select name,value,description,issys_modifiable from v$parameter where name='smtp_out_server'

---SELECT * FROM TABLE(DBMS_NETWORK_ACL_UTILITY.DOMAINS('smtp.sendgrid.net'));

GRANT EXECUTE ON SYS.UTL_FILE TO CHADMOON;

GRANT EXECUTE ON UTL_FILE TO CHADMOON;

GRANT EXECUTE ON SYS.UTL_SMTP TO CHADMOON;

GRANT EXECUTE ON UTL_SMTP TO CHADMOON;

ALTER SYSTEM set smtp_out_server = 'smtp.sendgrid.net:25' SCOPE = BOTH;

GRANT EXECUTE ON SYS.UTL_MAIL TO CHADMOON;

GRANT EXECUTE ON UTL_TCP TO CHADMOON;

GRANT EXECUTE ON UTL_MAIL TO CHADMOON;

GRANT EXECUTE ON UTL_HTTP TO CHADMOON;

GRANT EXECUTE ON UTL_INADDR TO CHADMOON;