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

From Bosco Rama
Subject Re: Unprivileged access to pgsql functions?
Date
Msg-id 4D71602A.2060304@boscorama.com
Whole thread Raw
In response to Re: Unprivileged access to pgsql functions?  (Matt Warner <matt@warnertechnology.com>)
Responses Re: Unprivileged access to pgsql functions?  (Matt Warner <matt@warnertechnology.com>)
List 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.

pgsql-general by date:

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