From: Casey Allen Shobe <cshobe@softhome.net>
To: Devrim GUNDUZ <devrim@gunduz.org>
Cc: PostgreSQL Mailing Lists-SQL <pgsql-sql@postgresql.org>
Subject: Re: What am I doing wrong in here?
Date: Sat, 27 Dec 2003 11:53:20 -0500
Message-ID: <200312271153.20937.cshobe@softhome.net> (raw)
In-Reply-To: <Pine.LNX.4.44.0312271740080.26555-100000@emo.org.tr>
References: <Pine.LNX.4.44.0312271740080.26555-100000@emo.org.tr>
Devrim GUNDUZ (Saturday 27 December 2003 10:45)
> > > ERROR: permission denied for schema pg_catalog
> >
> > The user you create the user as needs to have createuser permission.
> > alter user "foo" with createuser;
> >
> > ...(run as an appropriate user) will grant the user such permission.
>
> Hmm, that solved the problem, thanks.
>
> But I still could not understand why the lack of createuser permission
> caused the error above...
Because database users (and lots of other database information) is stored in
the pg_catalog schema. When you create, alter, or drop a user, you are
performing an insert, update, or delete on pg_catalog.pg_shadow.
I'm not familiar enough with the internals to say exactly how createuser=t in
the same table grants update permission to the user, but that is the effect.
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey Allen Shobe)
cshobe@softhome.net / http://rivyn.livejournal.com
Jabber: sigthor@jabber.org; ICQ: 1494523; AIM/Yahoo: SomeLinuxGuy
Free development contributor of:
> KDE toolbar icons
> Kopete user interface, usability, and testing
> X11 Icelandic Dvorak keymaps
> Reporting of over 100 Kopete bugs
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: cshobe@softhome.net, devrim@gunduz.org
Subject: Re: What am I doing wrong in here?
In-Reply-To: <200312271153.20937.cshobe@softhome.net>
* 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