| From: | "Dinesh Pandey" <dpandey(at)secf(dot)com> |
|---|---|
| To: | "'Michael Glaesemann'" <grzm(at)myrealbox(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 09:34:59 |
| Message-ID: | 20050610094040.D756952861@svr1.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
> OR
> 3. Problem With Database user permission?
Only a superuser can create a pltclu function. "dbUSER" must be a
PostgreSQL superuser if it created the pltclu function. You client
must use a PostgreSQL superuser to create a pltclu function.
What do mean with super user. The user who has installed the Postgres (like
I have installed it using "Postgres" user) and initialized the pgsql/data?
I am able to create this pltcl function with another "dataman" user but the
same getting failed at out client end.
Now pls tell me how to fix it, so that I can tell our client.
> Now how to change permission of that user to be able to create this
> function?
Make sure the user creating the function is a PostgreSQL superuser.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-06-10 09:46:29 | Re: Reliably finding temporary table |
| Previous Message | Richard Huxton | 2005-06-10 09:11:18 | Re: [SQL] Permission denied for language pltclu |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dinesh Pandey | 2005-06-10 09:51:46 | Re: [SQL] Permission denied for language pltclu |
| Previous Message | Richard Huxton | 2005-06-10 09:11:18 | Re: [SQL] Permission denied for language pltclu |