From: Casey Allen Shobe <cshobe@softhome.net>
To: "PostgreSQL Mailing Lists-SQL" <pgsql-sql@postgresql.org>
Subject: Re: What am I doing wrong in here?
Date: Sat, 27 Dec 2003 17:56:29 -0500
User-Agent: KMail/1.5.94
References: <Pine.LNX.4.44.0312271740080.26555-100000@emo.org.tr>
	<200312271153.20937.cshobe@softhome.net>
	<12885.1072551003@sss.pgh.pa.us>
In-Reply-To: <12885.1072551003@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Message-Id: <200312271756.29959.cshobe@softhome.net>

Saturday 27 December 2003 13:50
> This analysis is nonsense ... system catalog operations do not do the
> same kinds of permission checks as user queries do.  Furthermore, if
> he'd not had permissions to create users, the initial CREATE USER
> command would have failed, and so would CREATE DATABASE (since it would
> then be specifying a nonexistent owner name).

The CREATE USER *did* fail, didn't it?  I'm sorry if I was inaccurate in my=
=20
response, but I don't believe I was - I think maybe we're just interpreting=
=20
the E-Mail two different ways.  Devrim, if you could copy and paste exactly=
=20
what you're doing and exactly where the errors appear in a psql session, th=
at=20
would be most helpful.

I did nat say that the user had to be a superuser, only that the user had t=
o=20
have createuser permission in order to CREATE USER.  And the last sentence =
of=20
the first paragraph may not be syntactically accurate because I am not=20
familiar with PostgreSQL's internals, but that is the effect of creating a=
=20
user, as I said in the second paragraph.

> My guess is that Devrim interpreted your suggestion as telling him to
> make the created user (tdmsoftmailserveruser) a superuser, which would
> naturally suppress any and all permissions failures for operations
> executed by that user.  That's hardly a reasonable answer to his problem
> though.

That is *NOT* what I suggested at all.

> As to what his real problem is, I dunno, but I'd like to find out.

Sure.

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