This is an old revision of the document!
Table of Contents
Wallet_/_ACL_/_Network_Access
Nice, clear example found on AskTOM
Create a wallet
0@@
Create an ACL
1@@
Add privilege to ACL
2@@
Open the wallet and use UTL_HTTP to retrieve a web page
3@@
Configure Fine-Grained Access to External Network Services
Oracle Database 11g Release 1 (11.1) includes fine-grained access control to the UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP, or UTL_INADDR packages using Oracle XML DB.<br /> If you have applications that use one of these packages, you must install Oracle XML DB if it is not already installed.<br /> You must also configure network access control lists (ACLs) in the database before these packages can work as they did in prior releases.<br /> <br /> The following example first looks for any ACL currently assigned to host_name.<br /> If one is found, then the example grants user_name the CONNECT privilege in the ACL only if that user does not already have it.<br /> If no ACL exists for host_name, then the example creates a new ACL called ACL_name, grants the CONNECT privilege to user_name, and assigns the ACL to host_name.
4@@