Re: ACL with roles.
Date: Thu, 23 Oct 2008 07:42:47 -0700 (PDT)
On 23 Oct, 15:31, "Preston" <dontwant..._at_nowhere.invalid> wrote:
> 220.127.116.11.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?
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