Re: Syntax Help Requested

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Syntax Help Requested
Дата
Msg-id 1145293906.9080.13.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Syntax Help Requested  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general
>    When I request a list of databases (psql -l), the one named contacts is
> there. However, when I open the database (psql contacts), there's no one
> home; that is, 'psql -d' returns 'no relations found.'
>
>    I need a clue on how to let user 'xrms' access the database 'contacts' so
> the install script runs correctly.

You can't grant all on multiple objects. You have to grant on each
object explicitly.

Joshua D. Drake



>
> TIA,
>
> Rich
>
--

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/





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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Syntax Help Requested
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Will changing the server date/time cause problems?