| From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
|---|---|
| To: | <dpandey(at)secf(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, PostgreSQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: [SQL] Permission denied for language pltclu |
| Date: | 2005-06-10 10:26:43 |
| Message-ID: | 77E71A0A-10BF-486F-AE02-B4A697038C6B@myrealbox.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dawid Kuroczko | 2005-06-10 10:27:32 | Inherits and "get highest id". |
| Previous Message | Richard Huxton | 2005-06-10 10:16:43 | Re: [SQL] Permission denied for language pltclu |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Davis | 2005-06-10 10:31:34 | Re: [SQL] Permission denied for language pltclu |
| Previous Message | Richard Huxton | 2005-06-10 10:16:43 | Re: [SQL] Permission denied for language pltclu |