From: Dinesh Pandey <dpandey@secf.com>
To: 'Richard Huxton' <dev@archonet.com>
Cc: 'Michael Glaesemann' <grzm@myrealbox.com>
Cc: pgsql-general@postgresql.org
Cc: 'PostgreSQL' <pgsql-sql@postgresql.org>
Subject: Re: [SQL] Permission denied for language pltclu
Date: Fri, 10 Jun 2005 15:21:46 +0530
Message-ID: <20050610095655.0215752956@svr1.postgresql.org> (raw)
In-Reply-To: <42A95936.3060002@archonet.com>
Hi Richard/ Michael
Thanks for your great help.
I got the problem.
Actually, I was not getting the cause of this problem, because it was
working properly at our end.
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
Thanks
Dinesh Pandey
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Richard Huxton
Sent: Friday, June 10, 2005 2:41 PM
To: dpandey@secf.com
Cc: 'Michael Glaesemann'; pgsql-general@postgresql.org; 'PostgreSQL'
Subject: Re: [GENERAL] [SQL] Permission denied for language pltclu
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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
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: dpandey@secf.com, dev@archonet.com, grzm@myrealbox.com, pgsql-general@postgresql.org
Subject: Re: [SQL] Permission denied for language pltclu
In-Reply-To: <20050610095655.0215752956@svr1.postgresql.org>
* 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