From: Dinesh Pandey <dpandey@secf.com>
To: 'Michael Glaesemann' <grzm@myrealbox.com>
Cc: 'pgsql-general' <pgsql-general@postgresql.org>
Cc: 'PostgreSQL' <pgsql-sql@postgresql.org>
Subject: Re: [SQL] Permission denied for language pltclu
Date: Fri, 10 Jun 2005 15:04:59 +0530
Message-ID: <20050610094040.D756952861@svr1.postgresql.org> (raw)
In-Reply-To: <E6321939-5F45-4E3C-A19B-CEE8BBB7E330@myrealbox.com>
> 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.
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, grzm@myrealbox.com, pgsql-general@postgresql.org
Subject: Re: [SQL] Permission denied for language pltclu
In-Reply-To: <20050610094040.D756952861@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