Re: problem on granting privilige to a function?

You need to either reference the function with the user name i.e. select test.get_count(.... ) or you will need to create a synonym (private or public) that points to the function. The private synonym would be created when logged in as yliu.

Patrick Flahan
flahan_at_earthlink.net

<yliu_at_creighton.edu> wrote in message
news:Pine.HPP.3.95.990414143107.15399A-100000_at_penguin.creighton.edu...
> Hi All,
>
> I create a function called get_count(account IN number, claim IN number)
> under my username test. Then I issued a "grant all on get_count to yliu"
> (yliu my another username. However, when I log into SQL*PLUS under
> yliu/passwd, I tried to execute the function "select get_count(84384, 1)
> from dual", however it told me that get_count is invalid column name.
> Could someone tell me what the problem is?
>
> Thanks in advance.
>
> yliu_at_creighton.edu
>
Received on Wed Apr 14 1999 - 15:10:21 CDT