After a 10g to 11gr2 upgrade, we are getting ORA-29273 errors when we try to use the
SYS.UTL_HTTP package. Our upgrade list requires ACL to be disabled.
How can we resolve this problem without enabling ACL?
I'm afraid your requirements cannot be met. If you want to use
If you don't care about the security implications, the simplest thing to do would be to create an ACL that allows access to everything, and assign it to all the database users that need to use the functions.
The Fine-Grained Access to Network Services in Oracle Database 11g article has an example of how to do that:
If you need to assign that ACL to other users, use: