create function (plgsql): permission denied

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

Greetings,

I have a user, owner a schema, but I just can't create any function
plgsql through that user. I got the error message: "plpgsql: permission
denied".

I don't know how can I grant permission to create functions for that
user (preferable way) or trust plpgsql language as a trusted language
(alternative way).

These are my definitions languages:

select * from pg_language ;
lanname | lanispl | lanpltrusted | lanplcallfoid | lanvalidator | lanacl
----------+---------+--------------+---------------+--------------+--------
plpgsql | t | f | 20893 | 0 |
sql | f | t | 0 | 2248 | {=U}
internal | f | f | 0 | 2246 | {=}
c | f | f | 0 | 2247 | {=}

In addition, could anyone explain me these table attributes?

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Pedro Salazar 2003-04-07 12:15:43 Re: create function (plpgsql): permission denied
Previous Message Mendola Gaetano 2003-04-07 08:54:21 Re: Duplicate primary key and also the OID !!!!