From: | Matt Warner <matt(at)warnertechnology(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Unprivileged access to pgsql functions? |
Date: | 2011-03-04 21:11:59 |
Message-ID: | AANLkTik_KPL6hhFH2V0Qsa4nHX6Aft6Kf7dp+vaSpCs9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Good afternoon.
I've been looking at the Oracle Functionality package. It's very
interesting. However, the one place I'm stuck is that while user Postgres
can access the functions, no other user seems to have access. I'm sure this
is something simple I'm missing, but so far Google hasn't shown me the
answer.
I've already tried explicitly granting execute permissions on the function,
and the search path, as I understand it, is already supposed to be looking
in pg_catalog.
Any pointers?
**** Non-privileged user*
offload=> select nvl(null,1);
ERROR: function nvl(unknown, integer) does not exist
LINE 1: select nvl(null,1);
^
HINT: No function matches the given name and argument types. You might need
to add explicit type casts.
offload=> \q
-bash-3.00$
**** Postgres user*
-bash-3.00$ psql
psql (9.0.3)
Type "help" for help.
postgres=# select nvl(null,1);
nvl
-----
1
(1 row)
postgres=# \q
TIA,
Matt
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2011-03-04 21:20:03 | Re: Unprivileged access to pgsql functions? |
Previous Message | Rayner Julio Rodríguez Pimentel | 2011-03-04 20:05:21 | Re: I need your help to get opinions about this situation |