Re: [SQL] Permission denied for language pltclu

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Richard Huxton
Sent: Friday, June 10, 2005 2:41 PM
To: dpandey(at)secf(dot)com
Cc: 'Michael Glaesemann'; pgsql-general(at)postgresql(dot)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