Re: ACL with roles.

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

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