Re: Oracle Function Ownership Problem

[Svend Jensen]

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:
>
SQLselect FOO(123) from dual;
>
>
If I am oracle user FRED (and I have permission) I can say:
>
SQLselect BOB.FOO(123) from dual;
>
>
Question: How can I change the ownership/permission/scope of the
function so I can say:
>
SQLselect 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