Re: problem with databases

Поиск
Список
Период
Сортировка
От Oliver Elphick
Тема Re: problem with databases
Дата
Msg-id 200004260603.e3Q639F08609@linda.lfix.co.uk
обсуждение исходный текст
Ответ на problem with databases  ("Martin A. Marques" <martin@math.unl.edu.ar>)
Список pgsql-general
"Martin A. Marques" wrote:
  >I'm trying to get IMP to work, and I need to create 2 databases which I have
  >problems creating.
  >What I get is this:
  >
  >GRANT SELECT, INSERT, UPDATE ON active_sessions, auth_user, auth_user_md5 TO
      > nobody;
  >ERROR:  aclparse: non-existent user "nobody"
  >
  >I don't know how to add the user nobody to grant him with permission to
  >connect to the horde database.

CREATE USER nobody NOCREATEDB NOCREATEUSER

I don't think there is any easy way to give a user access to a whole
database, except by granting permission on each object separately.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Submit yourselves therefore to God. Resist the devil,
      and he will flee from you."          James 4:7



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

Предыдущее
От: Jeffrey
Дата:
Сообщение: Re:
Следующее
От: "Oliver Elphick"
Дата:
Сообщение: Re: Having trouble getting readline functional in psql