Re: Unprivileged access to pgsql functions?
| От | Matt Warner |
|---|---|
| Тема | Re: Unprivileged access to pgsql functions? |
| Дата | |
| Msg-id | AANLkTimh=xtyqKsNget0nFaT0QUe_V1ApTej8sawN0zK@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Unprivileged access to pgsql functions? (Andrew Sullivan <ajs@crankycanuck.ca>) |
| Ответы |
Re: Unprivileged access to pgsql functions?
|
| Список | pgsql-general |
On Fri, Mar 4, 2011 at 1:51 PM, Andrew Sullivan <ajs@crankycanuck.ca> wrote:
On Fri, Mar 04, 2011 at 01:41:34PM -0800, Matt Warner wrote:Is the function in your search_path?
> 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.
A
--
Andrew Sullivan
ajs@crankycanuck.ca
Not sure. I believe public and pg_catalog are in the path by default. Most of the create function declarations prepend pg_catalog, and I believe I saw somewhere that pg_catalog is the default. But I may be misunderstanding that...
В списке pgsql-general по дате отправления: