Re: Unprivileged access to pgsql functions?

From: Bosco Rama <postgres(at)boscorama(dot)com>
To: Matt Warner <matt(at)warnertechnology(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unprivileged access to pgsql functions?
Date: 2011-03-04 21:56:58
Message-ID: 4D71602A.2060304@boscorama.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Matt Warner wrote:
>
> The function cannot be defined in the user's DB because "language C" is
> considered a security risk, so only the superuser can do that. Or that's
> what I get from reading anyway...

psql -U postgres -d user_db

will allow the superuser to then define the function in the user's DB.

Once there, you can grant access, if needed.

Bosco.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matt Warner 2011-03-04 21:57:19 Re: Unprivileged access to pgsql functions?
Previous Message Matt Warner 2011-03-04 21:55:34 Re: Unprivileged access to pgsql functions?