I dunno, but I'd like to find out.
Sure.
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 inte
Devrim GUNDUZ (Saturday 27 December 2003 10:45)
> But I still could not understand why the lack of createuser permission
> caused the error above...
Though I do think a more clear error in this case would be helpful (*hint
hint*).
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey Allen
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,
--
ve createuser permission.
select * from "pg_catalog"."pg_user";
...will show you all that you need to know.
alter user "foo" with createuser;
...(run as an appropriate user) will grant the user such permission.
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey All
any way to do this in one query?
Thank you,
--
Casey Allen Shobe, Open Source Software Solutions
[EMAIL PROTECTED] / http://www.osss.net / 770-653-4526
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
