Can't create superuser

Поиск
Список
Период
Сортировка
От Petr Plasil
Тема Can't create superuser
Дата
Msg-id Pine.LNX.3.94.1000126182428.21223A-100000@falcor.karlin.mff.cuni.cz
обсуждение исходный текст
Список 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







В списке pgsql-admin по дате отправления:

Предыдущее
От: ytnufu@myhome.net
Дата:
Сообщение: rachel.jpg 4678
Следующее
От: Sarah Officer
Дата:
Сообщение: ugly name clash