From: | Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com> |
---|---|
To: | <greg(at)turnstep(dot)com>, Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: I want to create a read only database for a specified user. |
Date: | 2010-11-16 19:11:32 |
Message-ID: | BLU149-W23571E06F0DC34248AAEDBD4370@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Greg, just what I asked for!
Chris
> From: greg(at)turnstep(dot)com
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] I want to create a read only database for a specified user.
> Date: Tue, 16 Nov 2010 18:10:33 +0000
>
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
>
> > I now want to have this database or all tables capable of read-only.
>
> ALTER DATABASE foo SET default_transaction_read_only = true;
>
> Easy to work around, but may be good enough for your purposes.
>
> - --
> Greg Sabino Mullane greg(at)turnstep(dot)com
> End Point Corporation http://www.endpoint.com/
> PGP Key: 0x14964AC8 201011161310
> http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
> -----BEGIN PGP SIGNATURE-----
>
> iEYEAREDAAYFAkziyQgACgkQvJuQZxSWSsg3ZACgsFsux4OcE2yBXI7mnxHGOcEY
> 7rIAn04PqcesABqlSM9aqDa0w7vO03J2
> =4Rr1
> -----END PGP SIGNATURE-----
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Derrick Rice | 2010-11-16 19:15:00 | Re: escape character for 'psql -c ' command |
Previous Message | Greg Sabino Mullane | 2010-11-16 18:10:33 | Re: I want to create a read only database for a specified user. |