Re: ACL with roles.

From: gazzag <>
Date: Thu, 23 Oct 2008 07:42:47 -0700 (PDT)
Message-ID: <>

On 23 Oct, 15:31, "Preston" <dontwant..._at_nowhere.invalid> wrote:
> 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

Privileges to run stored procedures have to be explicitly granted to the individual users, not roles.

Welcome back, btw.

HTH -g Received on Thu Oct 23 2008 - 09:42:47 CDT

Original text of this message