create function (plgsql): permission denied
От | Pedro Salazar |
---|---|
Тема | create function (plgsql): permission denied |
Дата | |
Msg-id | 1049715542.1132.14.camel@vitoria.intra.cet.pt обсуждение исходный текст |
Ответы |
Re: create function (plpgsql): permission denied
|
Список | 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 по дате отправления: