ACL with roles.

From: Preston <dontwantany_at_nowhere.invalid>
Date: 23 Oct 2008 14:31:23 GMT
Message-ID: <6mbg5rFfvkgfU1@mid.individual.net>

11.1.0.6.0 on Vista 64 Ultimate.

I've created a new ACL, assigned a host & added a privilege for a role, and can now do a utl_http.request when logged in as a user with that role. However if I put the utl_http.request in a procedure & try to run that, it fails with ORA-24247: network access denied by access control list (ACL).

If I add a privilige for the user to the ACL, it works. Anyone know where I'm going wrong?

-- 
Preston
Received on Thu Oct 23 2008 - 09:31:23 CDT

Original text of this message