Hello all.
I'm setting up a scheme (accounts, roles, etc.) for developing a web
application (oracle 8.04,designer 2.1.2,oracle web server 3.01).
a created a user toolkit_user that owns the toolkit packages (owa,htp,etc.).
- created public synonyms for the packages.
- created a role (wf_developer)
- granted execute privileges for the toolkit packages to the role.
- granted the role to a user (the developer).
When the developer tries to create a procedure, using the htp.print the
following message appears:
3/2 PLS-00201: identifier 'TOOLKIT_USER.HTP' must be declared
When I grant execute on htp to the developer directly, all works fine.
Is it not possible to use roles for this?
Regards
Gerrit.vanKammen_at_wkap.nl
Kluwer Academic Publishers
Spuiboulevard 50 3311GR Dordrecht
phone:0786392212 home:0786300488
Received on Sun Feb 28 1999 - 08:52:54 CST
