ACL parameter problem [message #404586] |
Fri, 22 May 2009 06:58 |
|
delna.sexy
Messages: 941 Registered: December 2008 Location: Surat, The Diamond City
|
Senior Member |
|
|
Hi all,
As I am using UTL_HTTP package, I am required to provide access using dbms_network_acl_admin.create_acl
But I am confused in providing value for argument 'host' in dbms_network_acl_admin.assign_acl
I had executed pl/sql block like
SQL> ed
Wrote file afiedt.buf
1 begin
2 dbms_network_acl_admin.assign_acl (
3 acl => 'utlpkg.xml',
4 host => '*',
5 lower_port => 1,
6 upper_port => 10000);
7* end;
SQL> /
PL/SQL procedure successfully completed.
SQL> select host, lower_port, upper_port, acl, aclid
2 from dba_network_acls
3 where ACL='/sys/acls/utlpkg.xml';
HOST
--------------------------------------------------------------------
LOWER_PORT UPPER_PORT
---------- ----------
ACL
--------------------------------------------------------------------
ACLID
--------------------------------
*
1 10000
/sys/acls/utlpkg.xml
43748F35D57D4372805BAED3A9978D0F
This is because I am required to access any website using UTL_HTTP package.
But while executing
DECLARE
P_URL_I VARCHAR2(200);
P_LINK_I VARCHAR2(200);
v_Return BOOLEAN;
BEGIN
P_URL_I := 'http://www.toppica.com/submit.php';
P_LINK_I := 'www.xlntseo.com';
v_Return := SEO_VERIFICATION.VERIFY_LINK(
P_URL_I => P_URL_I,
P_LINK_I => P_LINK_I
);
IF (v_Return) THEN
DBMS_OUTPUT.PUT_LINE('v_Return = ' || 'TRUE');
ELSE
DBMS_OUTPUT.PUT_LINE('v_Return = ' || 'FALSE');
END IF;
END;
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1674
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "XLNTSEO.SEO_VERIFICATION", line 8
ORA-06512: at "XLNTSEO.SEO_VERIFICATION", line 30
ORA-06512: at line 9
29273. 00000 - "HTTP request failed"
Dont know how to solve this proble.
Any clue?
regrds,
Delna
|
|
|
|
Re: ACL parameter problem [message #404625 is a reply to message #404602] |
Fri, 22 May 2009 08:50 |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
I can honestly say that I've never even heard of the packages that you're using here.
Any chance of a 5 line summary of what they're used for?
|
|
|
Re: ACL parameter problem [message #404628 is a reply to message #404625] |
Fri, 22 May 2009 09:03 |
|
Michel Cadot
Messages: 68722 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
If it is new in 11g.
http://www.oracle.com/pls/db111/ranked?word=dbms_network_acl_admin&remark=federated_search
Quote: | The DBMS_NETWORK_ACL_ADMIN package provides the interface to administer the network Access Control List (ACL).
|
Database Security Guide
Chapter 4 Configuring Privilege and Role Authorization
Section Managing Fine-Grained Access to External Network Services
Quote: | You can configure fine-grained access control for users and roles that need to access external network services from the database. This way, specific groups of users can connect to one or more host computers, based on privileges that you grant them. Typically, you use this feature to control access to applications that run on specific host addresses.
|
Quote: | To configure fine-grained access to database network services, you create an access control list (ACL), which is stored in Oracle XML DB. You can create the access control list by using Oracle XML DB itself, or by using the DBMS_NETWORK_ACL_ADMIN and DBMS_NETWORK_ACL_UTILITY PL/SQL packages.
|
Regards
Michel
|
|
|