Allow all hosts and ports using ACL

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2096
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Allow all hosts and ports using ACL

Post by admin »

BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'ERPSTUFF'',
principal_type => xs_acl.ptype_db));
END;
Malik Sikandar Hayat
Oracle ACE Pro
info@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest