| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | dpandey(at)secf(dot)com |
| Cc: | 'Michael Glaesemann' <grzm(at)myrealbox(dot)com>, pgsql-general(at)postgresql(dot)org, 'PostgreSQL' <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: [SQL] Permission denied for language pltclu |
| Date: | 2005-06-10 10:16:43 |
| Message-ID: | 42A9688B.1000303@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
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 | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2005-06-10 10:26:43 | Re: [SQL] Permission denied for language pltclu |
| Previous Message | Richard Huxton | 2005-06-10 10:03:37 | Re: how do you set foriegn keys in pgaccess? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2005-06-10 10:26:43 | Re: [SQL] Permission denied for language pltclu |
| Previous Message | KÖPFERL Robert | 2005-06-10 10:12:43 | How-to suggestions to views |