Postgres Pro
Downloads
Home   >   mailing lists

Re: Unprivileged access to pgsql functions? - Mailing list pgsql-general

From Matt Warner
Subject Re: Unprivileged access to pgsql functions?
Date
Msg-id AANLkTi=HxMP7ayu+VjJ=xXLkSOwbusfxCK-GX3dXJtqq@mail.gmail.com
Whole thread Raw
In response to Re: Unprivileged access to pgsql functions?  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
Responses Re: Unprivileged access to pgsql functions?  (Matt Warner <matt@warnertechnology.com>)
Re: Unprivileged access to pgsql functions?  (Bosco Rama <postgres@boscorama.com>)
Re: Unprivileged access to pgsql functions?  (John R Pierce <pierce@hogranch.com>)
Re: Unprivileged access to pgsql functions?  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
Re: Unprivileged access to pgsql functions?  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
Tree view
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@enterprisedb.com> 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@enterprisedb.com
Blog:http://vibhork.blogspot.com


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

pgsql-general by date:

Previous
From: Vibhor Kumar
Date:
Subject: Re: Unprivileged access to pgsql functions?
Next
From: Matt Warner
Date:
Subject: Re: Unprivileged access to pgsql functions?