GRANT USAGE ON DATABASE xxx TO public fails - Mailing list 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.

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