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: | Raw Message | Whole Thread | 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 |