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