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
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 |