Skip to main content

Posts

Showing posts from April, 2014

Oracle 11g (FGA) Access Control List

After got API for sending SMS and developed packages we tried to send URL, but we faced below known error. SQL> select alarmsender.pkg_sms_sender.send_sms('Ulfet','99450???????','test') from dual; ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1722 ORA-24247: network access denied by access control list (ACL) ORA-06512: at line 1 Starting Oracle 11g Oracle introduce FGA (Fine Grained Access) for using UTTL_HTTP, UTL_MAIL etc packages. After reading Oracle notes , we need to create ACL and then assgin it. Let`s check our db registery. SQL> set linesize 400 SQL> col comp_name format a40 SQL> select comp_name, status from dba_registry; COMP_NAME STATUS ---------------------------------------- -------------------------------------------- OWB VALID Oracle Application Express VALID Oracle Enterprise Manager VALID OLAP Catalog VALID Spatial VALID Oracle Multimedia V...