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) [EMAIL PROTECTED] / http://rivyn.livejournal.com Jabber: [EMAIL PROTECTED]; 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
