Can't create superuser

From: Petr Plasil <plasa(at)falcor(dot)karlin(dot)mff(dot)cuni(dot)cz>
To: pgsql-admin(at)postgreSQL(dot)org
Subject: Can't create superuser
Date: 2000-01-26 17:25:09
Message-ID: Pine.LNX.3.94.1000126182428.21223A-100000@falcor.karlin.mff.cuni.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I have a following problem:

I successfully did

CREATE USER user1
WITH PASSWIRD xxx
CREATEDB
CREATEUSER,

but when I connect as user1, I can't create other users - I am getting a
message
ERROR: defineUser: user "user1" does not have SELECT and INSERT privilege
for "pg_shadow".

I've checked pg_user - and he has both USESUPER and USECATUPD set.
The server uses PASSWORD autentification, but at the time of creation of
user1 this was set as TRUSTED - could this be the problem?.


Petr Plasil




Browse pgsql-admin by date

  From Date Subject
Next Message Sarah Officer 2000-01-26 22:01:53 ugly name clash
Previous Message ytnufu 2000-01-26 17:11:54 rachel.jpg 4678