X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1A98FD1B456 for ; Sat, 27 Dec 2003 17:02:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 64382-02 for ; Sat, 27 Dec 2003 13:01:28 -0400 (AST) Received: from jive.SoftHome.net (jive.SoftHome.net [66.54.152.27]) by svr1.postgresql.org (Postfix) with SMTP id 8B278D1B441 for ; Sat, 27 Dec 2003 13:01:27 -0400 (AST) Received: (qmail 2641 invoked by uid 417); 27 Dec 2003 17:01:27 -0000 Received: from tango-.softhome.net (HELO softhome.net) (172.16.2.14) by shunt-smtp-com-out-com-0 with SMTP; 27 Dec 2003 17:01:27 -0000 Received: from eirny.bellsouth.net ([68.215.193.149]) (AUTH: PLAIN cshobe@softhome.net) by softhome.net with esmtp; Sat, 27 Dec 2003 10:01:26 -0700 From: Casey Allen Shobe To: Devrim GUNDUZ Subject: Re: What am I doing wrong in here? Date: Sat, 27 Dec 2003 11:53:20 -0500 User-Agent: KMail/1.5.94 Cc: PostgreSQL Mailing Lists-SQL References: In-Reply-To: MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message-Id: <200312271153.20937.cshobe@softhome.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/205 X-Sequence-Number: 16371 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 i= n=20 the pg_catalog schema. When you create, alter, or drop a user, you are=20 performing an insert, update, or delete on pg_catalog.pg_shadow. I'm not familiar enough with the internals to say exactly how createuser=3D= t in=20 the same table grants update permission to the user, but that is the effect. Vertu s=E6ll, --=20 Sig=FE=F3r Bj=F6rn Jar=F0arson (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