Re: Grants for functions...

Also, you need to grant EXECUTE on fuction zz to user a too.

Ken Burnside wrote:
>
> I have two distinct users on a single system:
>
> User a owns table xx
>
> User b owns a function (zz) that does a count(*) from table xx.
>
> The function compiles without errors, but when executed from user a's
> connection... does not work... (reports a numeric or value error). What it
> does is return a null... instead of the number of rows..
>
> I have to grant the select priv. on table xx to user b in order for it to
> actually return the number of rows...
>
> Is this a bug.... and if so, is there a work around... ?
>
> Thanks..

--

Stanley Fung                 | Software Analyst
Mobile Data Solutions Inc.   | Direct Line: (604)207-6290
Suite 135                    | Tel:         (604)270-9939
10551 Shellbridge Way,       | Fax:         (604)270-1310
Richmond, B.C.               | E-Mail:      sfung_at_mdsi.bc.ca
Canada V6X-2W9               | http://www.mdsi-advantex.com

------------------------------------------------------------