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
 
 
 
 
 


************

Reply via email to