Hi,
What is the ACL going to be used for?
Is this an SMTP based ACL? Here is a simple example on how to add one -
begin
dbms_network_acl_admin.create_acl(
acl => 'utl_mail.xml',
description => 'Email Access',
principal => 'IFSAPP',
is_grant => TRUE,
privilege => 'connect');
dbms_network_acl_admin.add_privilege(
acl => 'utl_mail.xml',
principal => 'IFSAPP',
is_grant => TRUE,
privilege => 'resolve');
dbms_network_acl_admin.assign_acl(
acl => 'utl_mail.xml',
host => '<your_sever_name>');
end;
/
commit;
You can use the above example to add other type of ACLs.
You also need to make sure the necessary ACL level Grants are in place in the Oracle database.
Hi SriKanth
I was connect as sys and I made this processes but something is not OK.
Could you help with this “You also need to make sure the necessary ACL level Grants are in place in the Oracle database”.
I need to add privile resolve and connect to ifsapp an ifssys
Regards
If I understood you correctly, here are few examples on how to add grants (as SYS user):
grant execute on utl_http to ifsinfo;
grant execute on utl_http to ifsapp;
grant execute on utl_tcp to ifsapp;
grant execute on utl_tcp to ifsinfo;
grant execute on utl_smtp to ifsinfo;
grant execute on utl_smtp to ifsapp;