On Tue, Mar 2, 2010 at 9:56 AM, Thom Brown <thombrown@xxxxxxxxx> wrote: > 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. 9.0 will also have the hot standby feature. setting up a standby is pretty much always a good idea and access to the standby is automatically read only. this would be a cheap way to get what you want without dealing with privileges which is nice. you are also relatively insulated from problematic queries the user might make like accidental unconstrained joins, full table sorts etc.. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
