Re: GRANT EXECUTE ON MYFUNCTION TO SOMEROLE

From: L120bj <l120bj_at_aol.com>
Date: 1997/02/23
Message-ID: <19970223131800.IAA22254@ladder02.news.aol.com>#1/1

If JOE create a synonym as
CREATE SYNONYM MYFUNCTION FOR SALES.MYFUNCTION; then he can just reference it as
select....myfunction(...)

---

---

Subject: GRANT EXECUTE ON MYFUNCTION TO SOMEROLE From: "Tim Romano" <tim_at_ot.com>
Date: 15 Feb 1997 15:16:02 GMT
Message-ID: <01bc1b53$429fdda0$73f0eac7_at_haven>

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 Sun Feb 23 1997 - 00:00:00 CST