|
Thanks Greg, just what I asked for! Chris > From: greg@xxxxxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxxxxxxxx > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general |
