Postgres Pro
Downloads
Home   >   mailing lists

Re: How to grant a user read-only access to a database? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: How to grant a user read-only access to a database?
Date
Msg-id 4B8D2B6D.9030108@iol.ie
Whole thread Raw
In response to Re: How to grant a user read-only access to a database?  (Thom Brown <thombrown@gmail.com>)
Responses Re: How to grant a user read-only access to a database?  (Antonio Goméz Soto<antonio.gomez.soto@gmail.com>)
Re: How to grant a user read-only access to a database?  (Said Ramirez <sramirez@vonage.com>)
List pgsql-general
Tree view 
On 02/03/2010 14:56, Thom Brown wrote:
>>
>> But I still need to define access to each table separately?
>>
>> Thanks,
>> Antonio.
>>
>
> As far as I'm aware.  It's only in the upcoming version 9.0 that you
> can do things like:
>
> GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly;
>
> Other folk on here may have some alternative suggestions though.

I think people have in the past posted queries that extract the table
names from the system catalogues and then grant privileges on them....
it might be worthwhile having a trawl through the archives.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: How to grant a user read-only access to a database?
Next
From: "A. Kretschmer"
Date:
Subject: Re: to_timestamp() and quarters