GRANT USAGE ON DATABASE xxx TO public fails

From: "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: GRANT USAGE ON DATABASE xxx TO public fails
Date: 2013-02-12 11:36:27
Message-ID: A2E53AF8AE1C284C8F8B648653C0920B26E52BB8@EXXMAIL02.desktop.frd.metoffice.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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#//002p00000
007000000

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Kellerer 2013-02-12 11:52:22 Re: GRANT USAGE ON DATABASE xxx TO public fails
Previous Message Thomas Kellerer 2013-02-12 08:18:12 Re: Row Count