Home » SQL & PL/SQL » SQL & PL/SQL » ACL parameter problem (11g, server 2003)
ACL parameter problem [message #404586] Fri, 22 May 2009 06:58 Go to next message
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 #404602 is a reply to message #404586] Fri, 22 May 2009 07:43 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Ohhh!!!

I disconnected from Oracle once, and reconnected again.
And problem solved!! Shocked Smile

Thank god. Laughing

regards,
Delna
Re: ACL parameter problem [message #404625 is a reply to message #404602] Fri, 22 May 2009 08:50 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: need function for last month date?
Next Topic: Date comparison using DECODE
Goto Forum:
  


Current Time: Mon Dec 09 20:19:48 CST 2024