Re: Privilege Issue
- From: rjamya <rjamya@xxxxxxxxx>
- To: Nagarajan.Subbiah@xxxxxxxx
- Date: Thu, 3 Nov 2005 12:26:35 -0500
make sure that the x1@d1 has execute privs on that package. Where x1 is the
user you are trying to connect thru db-link from d2.
Raj
On 11/3/05, Subbiah, Nagarajan <Nagarajan.Subbiah@xxxxxxxx> wrote:
>
> Hi,
>
> I am getting an ORA-904 invalid identifier error when calling a package
> over the db link.
> Database D1 has a package P1 and Database D2 has the synonym S1 for the
> package P1 over the db link. When I call a function F1 in the package P1
> using the synonym S1 from D2,
> "Select S1.F1('123) from dual; " I am getting the above error ORa-904.
> What privilege I am missing and Can we not access the package over the db
> link?
> Don't have any issue with accesing the tables.
> Thanks,
> Raja.
>
>
--
------------------------------
Useful Links: FAQ1, FAQ2, RTFM, STFW, ORA-600, ORA-7445
Other related posts:
