From: Richard Huxton <dev@archonet.com>
To: dpandey@secf.com
Cc: Michael Glaesemann <grzm@myrealbox.com>
Cc: pgsql-general@postgresql.org, 'PostgreSQL' <pgsql-sql@postgresql.org>
Subject: Re: [SQL] Permission denied for language pltclu
Date: Fri, 10 Jun 2005 10:11:18 +0100
Message-ID: <42A95936.3060002@archonet.com> (raw)
In-Reply-To: <20050610084322.C25AF528AE@svr1.postgresql.org>
References: <20050610084322.C25AF528AE@svr1.postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, dpandey@secf.com, grzm@myrealbox.com
Subject: Re: [SQL] Permission denied for language pltclu
In-Reply-To: <42A95936.3060002@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox