GRANT EXECUTE ON MYFUNCTION TO SOMEROLE

Connected as the DB owner, SALES, I created a standalone (i.e., not part of a package) function, MYFUNCTION, and then I granted execute on MYFUNCTION to a role, SALES_ROLE. Prior to creating the function, I had granted SALES_ROLE to a user, JOE.

In SQL statements that JOE issues, JOE must prepend the name of the database owner to the function name:

SELECT ID, INVOICEAMT, SALES.MYFUNCTION(DUEDATE) FROM INVOICE Is there a way for user JOE to reference MYFUNCTION without prepending the DB owner name?

SELECT ID, INVOICEAMT, MYFUNCTION(DUEDATE) FROM INVOICE Please cc: me at tim_at_ot.com if you reply to the group. Thanks in advance.
Tim Received on Sat Feb 15 1997 - 00:00:00 CST