Thread: Can't create superuser

 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