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