| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Thom Brown <thombrown(at)gmail(dot)com> |
| Cc: | Antonio Goméz Soto <antonio(dot)gomez(dot)soto(at)gmail(dot)com>, Nilesh Govindarajan <lists(at)itech7(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to grant a user read-only access to a database? |
| Date: | 2010-03-03 14:29:21 |
| Message-ID: | b42b73151003030629y76ad1d7es718620617dffb28a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Mar 2, 2010 at 9:56 AM, Thom Brown <thombrown(at)gmail(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | akp geek | 2010-03-03 14:44:07 | Re: FSM and VM file |
| Previous Message | Bruce Momjian | 2010-03-03 14:25:29 | Re: [GENERAL] to_timestamp() and quarters |