GRANT USAGE ON DATABASE xxx TO public fails

Поиск
Список
Период
Сортировка
От Birchall, Austen
Тема GRANT USAGE ON DATABASE xxx TO public fails
Дата
Msg-id A2E53AF8AE1C284C8F8B648653C0920B26E52BB8@EXXMAIL02.desktop.frd.metoffice.com
обсуждение исходный текст
Ответы Re: GRANT USAGE ON DATABASE xxx TO public fails  (Thomas Kellerer <spam_eater@gmx.net>)
Re: GRANT USAGE ON DATABASE xxx TO public fails  (Philip Couling <phil@pedal.me.uk>)
Список pgsql-novice

8.4.13 on Red Hat 6 64 bit

 

Hi

 

I’m setting up a database to use with ESRI sde/arcgis  following

 

 

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002p00000007000000

 

This includes the step

 

1.    Grant usage privileges to the public or to specific roles and groups so other users can access the database.

2.  GRANT USAGE

3.  ON DATABASE agency

TO public;

 

 

Which fails and seems to be incorrect.

 

postgres=# GRANT USAGE ON DATABASE dmms  TO public;

ERROR:  invalid privilege type USAGE for database

postgres=#

 

An initial look at docs strongly suggests that this is the case.

 

Is there a different command I can run which will give the same outcome i.e. that public can access the database.

 

Many thanks

 

Austen Birchall

 

 

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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Row Count
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: GRANT USAGE ON DATABASE xxx TO public fails