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

From Matt Warner
Subject Re: Unprivileged access to pgsql functions?
Date
Msg-id AANLkTi=APhfFFU=kRMURe8ri91dOLKZfEb8AR2buH-8f@mail.gmail.com
Whole thread Raw
In response to Re: Unprivileged access to pgsql functions?  (Bosco Rama <postgres@boscorama.com>)
List pgsql-general


On Fri, Mar 4, 2011 at 1:56 PM, Bosco Rama <postgres@boscorama.com> wrote:
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.

Success! Too much exposure to Oracle had me forgetting that the databases are separate in Postgres. D'oh!

Thank you very much!

Matt

pgsql-general by date:

Previous
From: Matt Warner
Date:
Subject: Re: Unprivileged access to pgsql functions?
Next
From: Aleksey Tsalolikhin
Date:
Subject: Re: database is bigger after dump/restore - why? (60 GB to 109 GB)