Re: [SQL] Permission denied for language pltclu

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: [SQL] Permission denied for language pltclu
Дата
Msg-id 77E71A0A-10BF-486F-AE02-B4A697038C6B@myrealbox.com
обсуждение исходный текст
Ответ на Re: [SQL] Permission denied for language pltclu  ("Dinesh Pandey" <dpandey@secf.com>)
Ответы Re: [SQL] Permission denied for language pltclu  (Michael Glaesemann <grzm@myrealbox.com>)
Список pgsql-general
On Jun 10, 2005, at 6:51 PM, Dinesh Pandey wrote:
> Actually this problem occurs when the function is being created by
> the user who has not created the current database.
>
>
>
> Solution: The database must be created by the user who is creating
> the pltcl function? Right
This is a coincidence.

Only a PostgreSQL superuser can create a database, so a user who
created the database will be a superuser. Only a superuser can create
a function with an untrusted language. So, the same superuser can
both create a database and create the function using pltclu. However,
*any* PostgreSQL superuser should be able to create such a function,
regardless of whether they created the database or not.

Michael Glaesemann
grzm myrealbox com


В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: [SQL] Permission denied for language pltclu
Следующее
От: Dawid Kuroczko
Дата:
Сообщение: Inherits and "get highest id".