Home -> Usenet -> comp.databases.oracle -> Oracle Function Ownership Problem

Oracle Function Ownership Problem

From: Leo <leo_at_leobynum.com>
Date: 21 Jul 2003 13:27:28 -0700
Message-ID: <7a567f76.0307211227.334d1e9_at_posting.google.com> 






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?
Received on Mon Jul 21 2003 - 22:27:28 CEST












Original text of this message