Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Kill Session question - ThanX !
THANK You - that did it !
And that was really a fast response ... I love this group !
Jan=)
"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> schrieb im Newsbeitrag
news:b0rala$lr0$1_at_babylon.agtel.net...
> You're hitting the same problem observed by oh so many developers
> before: stored procedures do not inherit privileges from roles, they
always
> execute as if there are no roles active (with exception of AUTHID
> CURRENT_USER procedures, which do inherit privileges from roles, but
> they are executing under privileges of calling user, not SP owner.)
>
> Granting ALTER SESSION to MASTERMIND didn't do any good because
> you needed to grant ALTER SYSTEM for it to be able to alter the system
> (and that's what your EXECUTE IMMEDIATE tries to do.)
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> All opinions are mine and do not necessarily go in line with those of my
employer.
>
Received on Fri Jan 24 2003 - 06:20:32 CST