From dpandey@secf.com Fri Jun 10 07:16:38 2005 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 7F742528B7; Fri, 10 Jun 2005 04:16:38 -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 26710-05; Fri, 10 Jun 2005 07:16:35 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id D9BD8528AE; Fri, 10 Jun 2005 04:16:33 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001057366.msg; Fri, 10 Jun 2005 00:16:34 -0700 Reply-To: From: "Dinesh Pandey" To: , "'PostgreSQL'" Subject: Permission denied for language pltclu Date: Fri, 10 Jun 2005 12:40:39 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0054_01C56DB9.9DE958A0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVti4GCYl8Dk+kITtermhHUig3QgQ== X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Fri, 10 Jun 2005 00:16:34 -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 00:16:34 -0700 Message-Id: <20050610071633.D9BD8528AE@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.341 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200506/498 X-Sequence-Number: 79206 This is a multi-part message in MIME format. ------=_NextPart_000_0054_01C56DB9.9DE958A0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi, I am using Postgres-.8.0.1. I am creating a function with 'pltclu' language. I have already created database with 'pltclu' language. But on creation this function I am getting this error and failed to create this function ------------------------- ERROR: Permission denied for language pltclu ------------------------- What is the cause? Regards Dinesh Pandey ---------------------------------------------------------------------------- ------ Dinesh Pandey Sr. Software Engineer Second Foundation (India) Pvt. Ltd. Plot# 52 Industrial Area, Phase II Chandigarh. (India) PH: (O) 0172-2639202, Extn: 233 ------=_NextPart_000_0054_01C56DB9.9DE958A0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

I am using = Postgres-.8.0.1.

 

I am creating a function with = ‘pltclu’ language. I have = already created database with ‘pltclu’ language. But on creation this function I am getting this error and = failed to create this function

-------------------------<= /span>

ERROR<= /b>: Permission denied for language = pltclu

-------------------------<= /span>

What is the = cause?

Regards
Dinesh Pandey


-----------------------------------= -----------------------------------------------<= /font>
Dinesh = Pandey 
Sr. Software Engineer

Second Foundation (India) Pvt. Ltd.
Plot# 52
Industrial Area, Phase II
Chandigarh. (India)
PH: (O) 0172-2639202, Extn: 233

 

------=_NextPart_000_0054_01C56DB9.9DE958A0-- From grzm@myrealbox.com Fri Jun 10 07:28:32 2005 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 6457A528FF; Fri, 10 Jun 2005 04:28:32 -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 29072-05; Fri, 10 Jun 2005 07:28:20 +0000 (GMT) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id 6EF35528C6; Fri, 10 Jun 2005 04:28:17 -0300 (ADT) Received: from [172.16.1.182] glaesema [61.197.227.146] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.5 $ on Linux via secured & encrypted transport (TLS); Fri, 10 Jun 2005 01:28:18 -0600 In-Reply-To: <20050610071633.D9BD8528AE@svr1.postgresql.org> References: <20050610071633.D9BD8528AE@svr1.postgresql.org> Mime-Version: 1.0 (Apple Message framework v730) Content-Type: text/plain; charset=WINDOWS-1252; delsp=yes; format=flowed Message-Id: <3CEA5309-9B60-4972-A933-7DB8A66FD2C2@myrealbox.com> Cc: , "'PostgreSQL'" Content-Transfer-Encoding: quoted-printable From: Michael Glaesemann Subject: Re: [SQL] Permission denied for language pltclu Date: Fri, 10 Jun 2005 16:28:13 +0900 To: X-Mailer: Apple Mail (2.730) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/499 X-Sequence-Number: 79207 On Jun 10, 2005, at 4:10 PM, Dinesh Pandey wrote: > I am using Postgres-.8.0.1. > > > > I am creating a function with =91pltclu=92 language. I have already =20= > created database with =91pltclu=92language. But on creation this =20 > function I am getting this error and failed to create this function > > ------------------------- > > ERROR: Permission denied for language pltclu > > ------------------------- > > What is the cause? It means that the user you are creating the function as does not have =20= permission to use pltclu. Only superusers can create functions using =20 untrusted languages. http://www.postgresql.org/docs/8.0/interactive/pltcl.html Hope this helps. Michael Glaesemann grzm myrealbox com= From dpandey@secf.com Fri Jun 10 07:39:31 2005 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 C12CF528B1; Fri, 10 Jun 2005 04:39:31 -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 29940-06; Fri, 10 Jun 2005 07:39:22 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 40C5852896; Fri, 10 Jun 2005 04:39:21 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001057514.msg; Fri, 10 Jun 2005 00:39:25 -0700 Reply-To: From: "Dinesh Pandey" To: "'Michael Glaesemann'" Cc: , "'PostgreSQL'" Subject: Re: [SQL] Permission denied for language pltclu Date: Fri, 10 Jun 2005 13:03:29 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0061_01C56DBC.CEC19700" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <3CEA5309-9B60-4972-A933-7DB8A66FD2C2@myrealbox.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVtjiQyvHJ36LqLTLSNnDbumaPRKgAAAL8A X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Fri, 10 Jun 2005 00:39:25 -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 00:39:26 -0700 Message-Id: <20050610073921.40C5852896@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.335 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200506/500 X-Sequence-Number: 79208 This is a multi-part message in MIME format. ------=_NextPart_000_0061_01C56DBC.CEC19700 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I have installed the Postgres from "postgres" user with pltcl option and able to create these function with another dbUSER successfully and never get this error. But our client is getting this error, How to solve it now? Any Idea? Thanks Dinesh Pandey -----Original Message----- From: Michael Glaesemann [mailto:grzm@myrealbox.com] Sent: Friday, June 10, 2005 12:58 PM To: dpandey@secf.com Cc: pgsql-general@postgresql.org; 'PostgreSQL' Subject: Re: [SQL] Permission denied for language pltclu On Jun 10, 2005, at 4:10 PM, Dinesh Pandey wrote: > I am using Postgres-.8.0.1. > > > > I am creating a function with 'pltclu' language. I have already > created database with 'pltclu'language. But on creation this > function I am getting this error and failed to create this function > > ------------------------- > > ERROR: Permission denied for language pltclu > > ------------------------- > > What is the cause? It means that the user you are creating the function as does not have permission to use pltclu. Only superusers can create functions using untrusted languages. http://www.postgresql.org/docs/8.0/interactive/pltcl.html Hope this helps. Michael Glaesemann grzm myrealbox com ------=_NextPart_000_0061_01C56DBC.CEC19700 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I have installed the Postgres from “postgres” user with pltcl = option and able to create these function with another dbUSER successfully and never get = this error.

 

But our client is getting this error, How to solve it now? Any = Idea?

 

 

Thanks

Dinesh Pandey

 

-----Original Message-----
From: Michael Glaesemann [mailto:grzm@myrealbox.com]
Sent: Friday, June 10, 2005 12:58 PM
To: dpandey@secf.com
Cc: pgsql-general@postgresql.org; 'PostgreSQL'
Subject: Re: [SQL] Permission denied for language = pltclu

 

 

On Jun 10, 2005, at 4:10 PM, Dinesh Pandey = wrote:

> I am using Postgres-.8.0.1.

> 

> 

> 

> I am creating a function with ‘pltclu’ language. I have = already 

> created database with ‘pltclu’language. But on creation = this 

> function I am getting this error and failed to create this = function

> 

> -------------------------

> 

> ERROR: Permission denied for language = pltclu

> 

> -------------------------

> 

> What is the cause?

 

It means that the user you are creating the function as does not have  =

permission to use pltclu. Only superusers can create functions using  =

untrusted languages.

 

http://www.postgresql.org/docs/8.0/interactive= /pltcl.html

 

Hope this helps.

 

Michael Glaesemann

grzm myrealbox com

------=_NextPart_000_0061_01C56DBC.CEC19700-- From dev@archonet.com Fri Jun 10 08:31:06 2005 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 666ED52861; Fri, 10 Jun 2005 05:31:06 -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 46469-04; Fri, 10 Jun 2005 08:30:57 +0000 (GMT) Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by svr1.postgresql.org (Postfix) with ESMTP id 505B752921; Fri, 10 Jun 2005 05:30:56 -0300 (ADT) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 16E1940DA58; Fri, 10 Jun 2005 09:30:53 +0100 (BST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id D771A15ED7; Fri, 10 Jun 2005 09:28:40 +0100 (BST) Received: from mainbox.archonet.com ([127.0.0.1]) by localhost (mainbox [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22140-10; Fri, 10 Jun 2005 09:28:38 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 693E115ED5; Fri, 10 Jun 2005 09:28:38 +0100 (BST) Message-ID: <42A94F36.80902@archonet.com> Date: Fri, 10 Jun 2005 09:28:38 +0100 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: dpandey@secf.com Cc: 'Michael Glaesemann' , pgsql-general@postgresql.org, 'PostgreSQL' Subject: Re: [SQL] Permission denied for language pltclu References: <20050610073921.40C5852896@svr1.postgresql.org> In-Reply-To: <20050610073921.40C5852896@svr1.postgresql.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.054 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/501 X-Sequence-Number: 79209 Dinesh Pandey wrote: > I have installed the Postgres from "postgres" user with pltcl option and > able to create these function with another dbUSER successfully and never get > this error. > > But our client is getting this error, How to solve it now? Any Idea? If you created an untrusted function as user "dbUSER" then it was a superuser too. Honest. -- Richard Huxton Archonet Ltd From dpandey@secf.com Fri Jun 10 08:43:32 2005 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 DC122528B1; Fri, 10 Jun 2005 05:43:32 -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 50378-02; Fri, 10 Jun 2005 08:43:24 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id C25AF528AE; Fri, 10 Jun 2005 05:43:22 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001058126.msg; Fri, 10 Jun 2005 01:44:26 -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 14:08:29 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <42A94F36.80902@archonet.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVtlx6NUMpDeKgURLGzUxpyLmsYSgAAAPsg X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Fri, 10 Jun 2005 01:44:26 -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 01:44:26 -0700 Message-Id: <20050610084322.C25AF528AE@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.329 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200506/502 X-Sequence-Number: 79210 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? Or 2. Problem with system user permission executing that database? OR 3. Problem With Database user permission? Now how to change permission of that user to be able to create this function? ---------------------------- If you created an untrusted function as user "dbUSER" then it was a superuser too. Honest. ---------------------------- Thanks Dinesh From grzm@myrealbox.com Fri Jun 10 09:03:09 2005 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 94AF95294F; Fri, 10 Jun 2005 06:03:09 -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 51003-05; Fri, 10 Jun 2005 09:03:00 +0000 (GMT) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id 92874528FF; Fri, 10 Jun 2005 06:02:59 -0300 (ADT) Received: from [172.16.1.182] glaesema [61.197.227.146] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.5 $ on Linux via secured & encrypted transport (TLS); Fri, 10 Jun 2005 03:03:02 -0600 In-Reply-To: <20050610084322.C25AF528AE@svr1.postgresql.org> References: <20050610084322.C25AF528AE@svr1.postgresql.org> Mime-Version: 1.0 (Apple Message framework v730) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-general , PostgreSQL Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: [SQL] Permission denied for language pltclu Date: Fri, 10 Jun 2005 18:02:57 +0900 To: X-Mailer: Apple Mail (2.730) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/503 X-Sequence-Number: 79211 On Jun 10, 2005, at 5:38 PM, 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? No. > Or > 2. Problem with system user permission executing that database? No. > 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. > 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. Michael Glaesemann grzm myrealbox com From dev@archonet.com Fri Jun 10 09:15:27 2005 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 8C87E52947; Fri, 10 Jun 2005 06:15:27 -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 59875-01; Fri, 10 Jun 2005 09:15:26 +0000 (GMT) Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by svr1.postgresql.org (Postfix) with ESMTP id 1278C52932; Fri, 10 Jun 2005 06:15:25 -0300 (ADT) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 642A440C0ED; Fri, 10 Jun 2005 10:15:21 +0100 (BST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 45BF315ED7; Fri, 10 Jun 2005 10:11:22 +0100 (BST) Received: from mainbox.archonet.com ([127.0.0.1]) by localhost (mainbox [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23584-01; Fri, 10 Jun 2005 10:11:19 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 0BAFB15ED5; Fri, 10 Jun 2005 10:11:19 +0100 (BST) Message-ID: <42A95936.3060002@archonet.com> Date: Fri, 10 Jun 2005 10:11:18 +0100 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: dpandey@secf.com Cc: 'Michael Glaesemann' , pgsql-general@postgresql.org, 'PostgreSQL' Subject: Re: [SQL] Permission denied for language pltclu References: <20050610084322.C25AF528AE@svr1.postgresql.org> In-Reply-To: <20050610084322.C25AF528AE@svr1.postgresql.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.054 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/504 X-Sequence-Number: 79212 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 dpandey@secf.com Fri Jun 10 09:40:51 2005 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 29CB552869; Fri, 10 Jun 2005 06:40:51 -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 65213-03; Fri, 10 Jun 2005 09:40:42 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id D756952861; Fri, 10 Jun 2005 06:40:40 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001058617.msg; Fri, 10 Jun 2005 02:40:54 -0700 Reply-To: From: "Dinesh Pandey" To: "'Michael Glaesemann'" Cc: "'pgsql-general'" , "'PostgreSQL'" Subject: Re: [SQL] Permission denied for language pltclu Date: Fri, 10 Jun 2005 15:04:59 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0095_01C56DCD.C7865500" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVtm1yMo703yNUmRzeOe8MnyVdt5gAAtiEg X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Fri, 10 Jun 2005 02:40:54 -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:40:56 -0700 Message-Id: <20050610094040.D756952861@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.325 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200506/505 X-Sequence-Number: 79213 This is a multi-part message in MIME format. ------=_NextPart_000_0095_01C56DCD.C7865500 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit > 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. ------=_NextPart_000_0095_01C56DCD.C7865500 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

> 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.

 

------=_NextPart_000_0095_01C56DCD.C7865500-- From dpandey@secf.com Fri Jun 10 09:57:08 2005 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-- From dev@archonet.com Fri Jun 10 10:20:29 2005 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 2B9EB528BF; Fri, 10 Jun 2005 07:20:29 -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 74586-04; Fri, 10 Jun 2005 10:20:20 +0000 (GMT) Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by svr1.postgresql.org (Postfix) with ESMTP id 3E22252869; Fri, 10 Jun 2005 07:20:19 -0300 (ADT) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 105E840C3DD; Fri, 10 Jun 2005 11:20:15 +0100 (BST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 7F8B615ED7; Fri, 10 Jun 2005 11:16:46 +0100 (BST) Received: from mainbox.archonet.com ([127.0.0.1]) by localhost (mainbox [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 25290-09; Fri, 10 Jun 2005 11:16:43 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id C3B2515ED5; Fri, 10 Jun 2005 11:16:43 +0100 (BST) Message-ID: <42A9688B.1000303@archonet.com> Date: Fri, 10 Jun 2005 11:16:43 +0100 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: dpandey@secf.com Cc: 'Michael Glaesemann' , pgsql-general@postgresql.org, 'PostgreSQL' Subject: Re: [SQL] Permission denied for language pltclu References: <20050610095655.0215752956@svr1.postgresql.org> In-Reply-To: <20050610095655.0215752956@svr1.postgresql.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.054 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/509 X-Sequence-Number: 79217 Dinesh Pandey wrote: > 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 Not quite. Read the chapter on users I mentioned in the manuals. Then, try a "SELECT * FROM pg_user" and look at the "usesuper" column. Then, try "ALTER USER username CREATEUSER" and "ALTER USER username NOCREATEUSER" - see how these affect pg_user. In short, a "superuser" is a user who can create other users. -- Richard Huxton Archonet Ltd From grzm@myrealbox.com Fri Jun 10 10:27:09 2005 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 6ECFC5295A; Fri, 10 Jun 2005 07:27:09 -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 72680-10; Fri, 10 Jun 2005 10:27:05 +0000 (GMT) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id D337852945; Fri, 10 Jun 2005 07:27:04 -0300 (ADT) Received: from [61.198.172.99] glaesema [61.198.172.99] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.5 $ on Linux via secured & encrypted transport (TLS); Fri, 10 Jun 2005 04:27:05 -0600 In-Reply-To: <20050610095655.0215752956@svr1.postgresql.org> References: <20050610095655.0215752956@svr1.postgresql.org> Mime-Version: 1.0 (Apple Message framework v730) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <77E71A0A-10BF-486F-AE02-B4A697038C6B@myrealbox.com> Cc: pgsql-general , PostgreSQL Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: [SQL] Permission denied for language pltclu Date: Fri, 10 Jun 2005 19:26:43 +0900 To: X-Mailer: Apple Mail (2.730) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/510 X-Sequence-Number: 79218 On Jun 10, 2005, at 6:51 PM, Dinesh Pandey wrote: > 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 This is a coincidence. Only a PostgreSQL superuser can create a database, so a user who created the database will be a superuser. Only a superuser can create a function with an untrusted language. So, the same superuser can both create a database and create the function using pltclu. However, *any* PostgreSQL superuser should be able to create such a function, regardless of whether they created the database or not. Michael Glaesemann grzm myrealbox com From sdavis2@mail.nih.gov Fri Jun 10 10:32:49 2005 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 C08FF528C1 for ; Fri, 10 Jun 2005 07:32:49 -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 77279-06 for ; Fri, 10 Jun 2005 10:32:48 +0000 (GMT) Received: from mx5.net.nih.gov (mailfwd.nih.gov [165.112.130.36]) by svr1.postgresql.org (Postfix) with ESMTP id 3C9EF5288D for ; Fri, 10 Jun 2005 07:32:47 -0300 (ADT) Received: from mx5.net.nih.gov (localhost [127.0.0.1]) by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j5AAWnaq020874 for ; Fri, 10 Jun 2005 06:32:49 -0400 Received: from [128.231.145.14] (holmes.nhgri.nih.gov [128.231.145.14]) by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j5AAWnKd020871; Fri, 10 Jun 2005 06:32:49 -0400 In-Reply-To: <20050610095655.0215752956@svr1.postgresql.org> References: <20050610095655.0215752956@svr1.postgresql.org> Mime-Version: 1.0 (Apple Message framework v622) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: <0ff6b4042414d68d62a956cd6c5c2c92@mail.nih.gov> Content-Transfer-Encoding: quoted-printable Cc: Postgresql-General list From: Sean Davis Subject: Re: [SQL] Permission denied for language pltclu Date: Fri, 10 Jun 2005 06:31:34 -0400 To: X-Mailer: Apple Mail (2.622) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/513 X-Sequence-Number: 79221 On Jun 10, 2005, at 5:51 AM, Dinesh Pandey wrote: > > Hi Richard/ Michael > =A0 > Thanks for your great help. > =A0 > I got the problem. > =A0 > Actually, I was not getting the cause of this problem, because it was=20= > working properly at our end. > =A0 > Actually this problem occurs when the function is being created by the=20= > user who has not created the current database. > =A0 > Solution: The database must be created by the user who is creating the=20= > pltcl function? Right Dinesh, The user creating the function must be a superuser. The question to=20 ask is: How do I make a user a superuser? The answer is in the=20 documentation at these two links. It suffices to ALTER USER to have=20 CREATEUSER privileges to be a superuser. http://www.postgresql.org/docs/8.0/static/user-attributes.html http://www.postgresql.org/docs/8.0/static/sql-alteruser.html I hope this clarifies things a bit. Sean= From grzm@myrealbox.com Fri Jun 10 10:32:43 2005 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 EDE1B528FE; Fri, 10 Jun 2005 07:32:43 -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 78201-05; Fri, 10 Jun 2005 10:32:42 +0000 (GMT) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id 006E752869; Fri, 10 Jun 2005 07:32:40 -0300 (ADT) Received: from [61.198.172.99] glaesema [61.198.172.99] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.5 $ on Linux via secured & encrypted transport (TLS); Fri, 10 Jun 2005 04:32:42 -0600 Mime-Version: 1.0 (Apple Message framework v730) In-Reply-To: <77E71A0A-10BF-486F-AE02-B4A697038C6B@myrealbox.com> References: <20050610095655.0215752956@svr1.postgresql.org> <77E71A0A-10BF-486F-AE02-B4A697038C6B@myrealbox.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <04F2B068-40A5-4C32-82E3-A4E0C0D82910@myrealbox.com> Cc: , pgsql-general , PostgreSQL Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: [SQL] Permission denied for language pltclu Date: Fri, 10 Jun 2005 19:32:34 +0900 X-Mailer: Apple Mail (2.730) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/512 X-Sequence-Number: 79220 On Jun 10, 2005, at 7:26 PM, Michael Glaesemann wrote: > > On Jun 10, 2005, at 6:51 PM, Dinesh Pandey wrote: > >> 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 >> > This is a coincidence. > > Only a PostgreSQL superuser can create a database, so a user who > created the database will be a superuser. Only a superuser can > create a function with an untrusted language. So, the same > superuser can both create a database and create the function using > pltclu. However, *any* PostgreSQL superuser should be able to > create such a function, regardless of whether they created the > database or not. Ach! Should have checked the docs before I mailed. I'm wrong about only superusers creating databases. Richard's got it all right. :) Michael Glaesemann grzm myrealbox com From tino@wildenhain.de Fri Jun 10 10:38:12 2005 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 034F452862; Fri, 10 Jun 2005 07:38:12 -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 75446-09; Fri, 10 Jun 2005 10:38:03 +0000 (GMT) Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by svr1.postgresql.org (Postfix) with ESMTP id EAC7C5288D; Fri, 10 Jun 2005 07:38:02 -0300 (ADT) Received: from sabrina.peacock.de (074-016-066-080.eggenet.de [80.66.16.74]) by service-web.de (Postfix) with ESMTP id 3763B200039; Fri, 10 Jun 2005 12:38:03 +0200 (CEST) Subject: Re: [SQL] Permission denied for language pltclu From: Tino Wildenhain To: dpandey@secf.com Cc: 'Richard Huxton' , 'Michael Glaesemann' , pgsql-general@postgresql.org, 'PostgreSQL' In-Reply-To: <20050610095655.0215752956@svr1.postgresql.org> References: <20050610095655.0215752956@svr1.postgresql.org> Content-Type: text/plain Date: Fri, 10 Jun 2005 12:37:57 +0200 Message-Id: <1118399877.5605.19.camel@sabrina.peacock.de> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/514 X-Sequence-Number: 79222 Am Freitag, den 10.06.2005, 15:21 +0530 schrieb Dinesh Pandey: > 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 > No :-) But if you are able to create databases, you are a superuser :-) And as a superuser you can also create the untrusted functions. Please read a bit in the documentation - when you manage databases for a customer you have some responsibilities and should know your tools. From dpandey@secf.com Fri Jun 10 10:50:13 2005 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 E9CF25280A; Fri, 10 Jun 2005 07:50:13 -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 83646-07; Fri, 10 Jun 2005 10:50:05 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 9B36E52885; Fri, 10 Jun 2005 07:50:03 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001059325.msg; Fri, 10 Jun 2005 03:51:06 -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 16:15:08 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C2_01C56DD7.954F0FF0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <42A9688B.1000303@archonet.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcVtpnCJ98MJ+TV1S+GdSzBJLtGsFgAAvi0g X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Fri, 10 Jun 2005 03:51:06 -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 03:51:08 -0700 Message-Id: <20050610105003.9B36E52885@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.315 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200506/515 X-Sequence-Number: 79223 This is a multi-part message in MIME format. ------=_NextPart_000_00C2_01C56DD7.954F0FF0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit In short, a "superuser" is a user who can create other users. But if the user is not super user, he is not allowed to install the language 'plpgsql' and 'pltcl' for database. But my problem was the language is already installed but getting error on creation of the function. And if any one is creating this function who is not owner of database, this problem occurs. Thanks Dinesh Pandey ------=_NextPart_000_00C2_01C56DD7.954F0FF0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

In short, a "superuser" is a user who can create other = users.

 

But if the user is not super = user, he is not allowed to install the language 'plpgsql' and 'pltcl' for = database.

 

But my problem was the language = is already installed but getting error on creation of the = function.

 

And if any one is creating this = function who is not owner of database, this problem = occurs.

 

 

Thanks

Dinesh Pandey

 

------=_NextPart_000_00C2_01C56DD7.954F0FF0-- From dev@archonet.com Fri Jun 10 10:56:58 2005 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 05E4D528E0; Fri, 10 Jun 2005 07:56:58 -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 84992-06; Fri, 10 Jun 2005 10:56:52 +0000 (GMT) Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by svr1.postgresql.org (Postfix) with ESMTP id 6780D52885; Fri, 10 Jun 2005 07:56:49 -0300 (ADT) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 0E3CA40760B; Fri, 10 Jun 2005 11:56:45 +0100 (BST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 4076815ED7; Fri, 10 Jun 2005 11:51:59 +0100 (BST) Received: from mainbox.archonet.com ([127.0.0.1]) by localhost (mainbox [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26332-09; Fri, 10 Jun 2005 11:51:57 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 1105115ED5; Fri, 10 Jun 2005 11:51:57 +0100 (BST) Message-ID: <42A970CC.8020100@archonet.com> Date: Fri, 10 Jun 2005 11:51:56 +0100 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tino Wildenhain Cc: dpandey@secf.com, 'Michael Glaesemann' , pgsql-general@postgresql.org, 'PostgreSQL' Subject: Re: [SQL] Permission denied for language pltclu References: <20050610095655.0215752956@svr1.postgresql.org> <1118399877.5605.19.camel@sabrina.peacock.de> In-Reply-To: <1118399877.5605.19.camel@sabrina.peacock.de> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.054 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/516 X-Sequence-Number: 79224 Tino Wildenhain wrote: > > No :-) But if you are able to create databases, you are a superuser :-) > And as a superuser you can also create the untrusted functions. Not quite - if you can create USERS you are a superuser. -- Richard Huxton Archonet Ltd From tino@wildenhain.de Fri Jun 10 11:09:25 2005 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 ACD515288D; Fri, 10 Jun 2005 08:09:25 -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 86498-09; Fri, 10 Jun 2005 11:09:17 +0000 (GMT) Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by svr1.postgresql.org (Postfix) with ESMTP id C28645284D; Fri, 10 Jun 2005 08:09:14 -0300 (ADT) Received: from sabrina.peacock.de (074-016-066-080.eggenet.de [80.66.16.74]) by service-web.de (Postfix) with ESMTP id EBE4020003A; Fri, 10 Jun 2005 13:09:15 +0200 (CEST) Subject: Re: [SQL] Permission denied for language pltclu From: Tino Wildenhain To: Richard Huxton Cc: dpandey@secf.com, 'Michael Glaesemann' , pgsql-general@postgresql.org, 'PostgreSQL' In-Reply-To: <42A970CC.8020100@archonet.com> References: <20050610095655.0215752956@svr1.postgresql.org> <1118399877.5605.19.camel@sabrina.peacock.de> <42A970CC.8020100@archonet.com> Content-Type: text/plain Date: Fri, 10 Jun 2005 13:09:09 +0200 Message-Id: <1118401749.5605.21.camel@sabrina.peacock.de> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/518 X-Sequence-Number: 79226 Am Freitag, den 10.06.2005, 11:51 +0100 schrieb Richard Huxton: > Tino Wildenhain wrote: > > > > No :-) But if you are able to create databases, you are a superuser :-) > > And as a superuser you can also create the untrusted functions. > > Not quite - if you can create USERS you are a superuser. Yes I finally found out ;) It was one of these 2 privilegues... -- Tino Wildenhain From tino@wildenhain.de Fri Jun 10 11:10:36 2005 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 2121B52955; Fri, 10 Jun 2005 08:10:36 -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 86778-07; Fri, 10 Jun 2005 11:10:31 +0000 (GMT) Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by svr1.postgresql.org (Postfix) with ESMTP id 4268C52951; Fri, 10 Jun 2005 08:10:31 -0300 (ADT) Received: from sabrina.peacock.de (074-016-066-080.eggenet.de [80.66.16.74]) by service-web.de (Postfix) with ESMTP id 33C35200039; Fri, 10 Jun 2005 13:10:34 +0200 (CEST) Subject: Re: [SQL] Permission denied for language pltclu From: Tino Wildenhain To: dpandey@secf.com Cc: 'Richard Huxton' , 'Michael Glaesemann' , pgsql-general@postgresql.org, 'PostgreSQL' In-Reply-To: <20050610105003.9B36E52885@svr1.postgresql.org> References: <20050610105003.9B36E52885@svr1.postgresql.org> Content-Type: text/plain Date: Fri, 10 Jun 2005 13:10:27 +0200 Message-Id: <1118401827.5605.23.camel@sabrina.peacock.de> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/519 X-Sequence-Number: 79227 Am Freitag, den 10.06.2005, 16:15 +0530 schrieb Dinesh Pandey: > In short, a "superuser" is a user who can create other users. > But if the user is not super user, he is not allowed to install the > language 'plpgsql' and 'pltcl' for database. > But my problem was the language is already installed but getting error > on creation of the function. > And if any one is creating this function who is not owner of database, > this problem occurs. > No, thats only a coincidence. Check the docs pretty please :-) And try to send mails to mailinglist in plaintext. -- Tino Wildenhain