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

From Pedro Salazar
Subject create function (plgsql): permission denied
Date
Msg-id 1049715542.1132.14.camel@vitoria.intra.cet.pt
Whole thread Raw
Responses Re: create function (plpgsql): permission denied  (Pedro Salazar <pedro-b-salazar@ptinovacao.pt>)
List 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@ptinovacao.pt
PGP:0E129E31D803BC61


pgsql-admin by date:

Previous
From: "Mendola Gaetano"
Date:
Subject: Re: Duplicate primary key and also the OID !!!!
Next
From: Pedro Salazar
Date:
Subject: Re: create function (plpgsql): permission denied