Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Other user table reference in database package
How about we all take turns alphabetically.
Next time this question is asked, someone with a name starting with 'E' has a go. Then 'F' and so on.
Hey, why not make it a competition. The letter which answer's this question the fastest becomes the letter of the year !!
I think I might lie down now ...
Richard
dudester wrote:
>
> Faisal Qasim wrote:
> > Dear all,
> >
> > We are trying to access another user's tables in a database package.
> > Those tables are successfully accessible from SQL directly as well as
> > through synonym and proper permission is there. Oracle 7.3.4 is being
> > used.
> >
> > Why does another user tables cannot be accessed in db. package? Are we
> > missing something.
> >
> > I would be grateful for any hints.
>
> Well, since Sy won't answer this question I guess it's up to me to save
> the day !!!
>
> Permissions granted to individual users via roles are not propogated in
> packages. You need to grant the privileges to the package as well.
>
> >
> >
> > Regards
> >
> > Faisal Qasim