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@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:13:21 CST
