Re: create function (plpgsql): permission denied

From: Pedro Salazar <pedro-b-salazar(at)ptinovacao(dot)pt>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: create function (plpgsql): permission denied
Date: 2003-04-07 12:15:43
Message-ID: 1049717743.1128.21.camel@vitoria.intra.cet.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings,

On Mon, 2003-04-07 at 12:39, Pedro Salazar wrote:
> select * from pg_language ;
> lanname | lanispl | lanpltrusted | lanplcallfoid | lanvalidator | lanacl
> ----------+---------+--------------+---------------+--------------+--------
> plpgsql | t | f | 20893 | 0 |

I updated the 'lanpltrusted' attribute to true, and now I can create
functions.

But, is it possible that only a group or a specified list of users have
permission to create plpgsql functions instead trust the language for
all users?

thanks,
Pedro Salazar.
--
PS
pedro-b-salazar(at)ptinovacao(dot)pt
PGP:0E129E31D803BC61

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Gunther 2003-04-07 12:53:33 Re: create function (plpgsql): permission denied
Previous Message Pedro Salazar 2003-04-07 11:39:03 create function (plgsql): permission denied