Postgres Pro
Downloads
Home   >   mailing lists

Re: create function (plpgsql): permission denied - Mailing list pgsql-admin

From Tom Lane
Subject Re: create function (plpgsql): permission denied
Date
Msg-id 27866.1049725806@sss.pgh.pa.us
Whole thread Raw
In response to Re: create function (plpgsql): permission denied  (John Gunther <inbox@bucksvsbytes.com>)
List pgsql-admin
Tree view 
John Gunther <inbox@bucksvsbytes.com> writes:
> This will grant <desireduser> the usage of plpgsql even if it is untrusted.

No.  Untrusted languages can be used only by superusers, period.  USAGE
is for controlling non-superusers' access to trusted languages.

            regards, tom lane

pgsql-admin by date:

Previous
From: John Gunther
Date:
Subject: Re: create function (plpgsql): permission denied
Next
From: Pedro Salazar
Date:
Subject: Re: create function (plpgsql): permission denied