Re: Unprivileged access to pgsql functions?

[Matt Warner <matt@xxxxxxxxxxxxxxxxxxxx>]

Here's how the script is defining the function, if that helps:

CREATE FUNCTION nvl(anyelement, anyelement)

RETURNS anyelement

AS '$libdir/orafunc','ora_nvl'

LANGUAGE C IMMUTABLE;

On Fri, Mar 4, 2011 at 1:41 PM, Matt Warner <matt@xxxxxxxxxxxxxxxxxxxx> wrote:

No luck:

*** as postgres

postgres=# GRANT all on function nvl(anyelement,anyelement) to public;

GRANT

postgres=# 

*** as unprivileged user

offload=> select nvl(0,1);

ERROR:  function nvl(integer, integer) does not exist

LINE 1: select nvl(0,1);

               ^

HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

On Fri, Mar 4, 2011 at 1:34 PM, Vibhor Kumar <vibhor.kumar@xxxxxxxxxxxxxxxx> wrote:

On Mar 5, 2011, at 2:50 AM, John R Pierce wrote:

> On 03/04/11 1:11 PM, Matt Warner wrote:
>> Good afternoon.
>>
>> I've been looking at the Oracle Functionality package. ...
>
> what is this?  doesn't sound like anything in PostgreSQL I'm familiar with.  Is this part of EntepriseDB's Postgres+ package or something?  You should probably contact them via their support channels.

GRANT all on function nvl to public would help.


Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@xxxxxxxxxxxxxxxx
Blog:http://vibhork.blogspot.com

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general