X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0CD545295C; Fri, 10 Jun 2005 06:57:08 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68329-02; Fri, 10 Jun 2005 09:56:58 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 0215752956; Fri, 10 Jun 2005 06:56:55 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001058799.msg; Fri, 10 Jun 2005 02:57:42 -0700 Reply-To: From: "Dinesh Pandey" To: "'Richard Huxton'" Cc: "'Michael Glaesemann'" , , "'PostgreSQL'" Subject: Re: [SQL] Permission denied for language pltclu Date: Fri, 10 Jun 2005 15:21:46 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00A7_01C56DD0.20929670" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <42A95936.3060002@archonet.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVtnU2m0DEcnv9SSl2yZlMyDM5IMAABA1IA X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Fri, 10 Jun 2005 02:57:42 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDAV-Processed: mail.secf.com, Fri, 10 Jun 2005 02:57:42 -0700 Message-Id: <20050610095655.0215752956@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.32 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200506/507 X-Sequence-Number: 79215 This is a multi-part message in MIME format. ------=_NextPart_000_00A7_01C56DD0.20929670 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_00A7_01C56DD0.20929670 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

------=_NextPart_000_00A7_01C56DD0.20929670--