| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | dpandey(at)secf(dot)com |
| Cc: | 'Michael Glaesemann' <grzm(at)myrealbox(dot)com>, 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:11:18 |
| Message-ID: | 42A95936.3060002@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Dinesh Pandey wrote:
> Sorry I didn't get it exactly. Because the same function (send e-mail) I am
> able to create at my end, but our client is not able to create it at their
> end.
>
> 1. Is there some problem in installation?
> 2. Problem with system user permission executing that database?
> 3. Problem With Database user permission?
Number 3 - it is to do with a PostgreSQL user account. That user needs
to be a superuser.
> Now how to change permission of that user to be able to create this
> function?
A good place to start with this sort of thing is the manuals. In the 7.4
manuals, I'd start with:
Ch 36.1. Installing Procedural Languages
Ch 17.2. User Attributes
Reference I - the "ALTER USER" command
Note that you may want to make the client's user a superuser just long
enough to install the language and/or functions.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dinesh Pandey | 2005-06-10 09:34:59 | Re: [SQL] Permission denied for language pltclu |
| Previous Message | Michael Glaesemann | 2005-06-10 09:02:57 | Re: [SQL] Permission denied for language pltclu |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dinesh Pandey | 2005-06-10 09:34:59 | Re: [SQL] Permission denied for language pltclu |
| Previous Message | Michael Glaesemann | 2005-06-10 09:02:57 | Re: [SQL] Permission denied for language pltclu |