Adding user to ACL list

As system user ,

--------

begin

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'EBS.xml',principal => 'XXUSER',is_grant => true, privilege => 'connect');

end;

commit;

--------

Use full script - How To Verify Current ACL Settings For Network Resources

If you get - ORA-24247 "network access denied by access control list (ACL)"

-- list ACL setup

connect / as sysdba

set pagesize 999

col host format a30
col acl format a30
col principal format a20
col start_date for a20
col end_date for a20
col lport for 9999
col uport for 99999
col R for a1
col G for a1

set echo on

spool support_acl.txt

select * from v$version;

show parameter smtp

SELECT host, acl, lower_port lport, upper_port uport
FROM DBA_NETWORK_ACLS ;

SELECT acl,principal,
  decode(u.type#,0,'*',1,' ') "R",
  decode(u.password,'GLOBAL','*') "G",
privilege,is_grant,
to_char(start_date,'YYYY-MON-DD') start_date,
to_char(end_date,'YYYY-MON-DD') end_date
FROM dba_network_acl_privileges p, user$ u
where u.name=p.principal;

spool off

-- end list ACL setup