Re: ACL with roles.
Date: 23 Oct 2008 15:10:22 GMT
> 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?
> > --
> > Preston
> Privileges to run stored procedures have to be explicitly granted to
> the individual users, not roles.
The user owns the procedure so that's not the issue. Or are you saying that specifically the ACL privilige has to be granted to individual users to run stored procedures?
> Welcome back, btw.
Why thank you kind sir!
-- PrestonReceived on Thu Oct 23 2008 - 10:10:22 CDT