Re: Oracle Function Ownership Problem

Leo wrote:

> Folks,
>
> I have a simple Oracle function question.
>
> I have written an oracle function (in java; Username: BOB; Function
> name:FOO) It works fine.
>
> If I am oracle user BOB I can say:
>
> SQL> select FOO(123) from dual;
>
>
> If I am oracle user FRED (and I have permission) I can say:
>
> SQL> select BOB.FOO(123) from dual;
>
>
> Question: How can I change the ownership/permission/scope of the
> function so I can say:
>
> SQL> select FOO(123) from dual;
>
> Without any OWNER.prefix no matter what oracle user I am logged in as?
>
> Any ideas?
A synonym will do.

/Svend Received on Tue Jul 22 2003 - 20:10:09 CEST