Home » SQL & PL/SQL » SQL & PL/SQL » Can PLSQL procs/functions refer to objets of other users
Can PLSQL procs/functions refer to objets of other users [message #40158] Thu, 12 September 2002 00:30 Go to next message
smy
Messages: 2
Registered: September 2002
Junior Member
if i do
select * from myuser.mytable on the sql prompt, it works.

However, it fails when I do the same in a procedure.

Any pointers?

rgds
-s

Report message to a moderator

Re: Can PLSQL procs/functions refer to objets of other users [message #40159 is a reply to message #40158] Thu, 12 September 2002 00:47 Go to previous message
smy
Messages: 2
Registered: September 2002
Junior Member
Got the solution from
http://www.orafaq.net/faqplsql.htm#ORJAVA:

Privilidges granted through roles are not considered in PLSQL.

The solution was to do a direct - grant select on tabname to username

Report message to a moderator

Previous Topic: PL/SQL declaration problem !!
Next Topic: pls-307 run-time
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 18:06:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.