Thanks for that - I am going to do that too!
I must admit I thought that ‘readonly’ might have been a parameter of
the database connection and I looked for that, but apparently not.
I know some vendors (such as Oracle) support a restricted mode, but it
requires connecting to the database first, then immediately issuing an
“alter session” command. How you would implement that in Rails I’m not
sure. Perhaps some sort of “post_connect” method?
Oh, definitely. This was just the way to do it through Rails, not at the
DB layer. And, like you said, you can always write it in such a way as
to track anyone who attempts to make a write attempt (presumably through
a backend interface, such as xml-rpc).
Thanks again for the ideas.
This communication is the property of Qwest and may contain confidential
privileged information. Unauthorized use of this communication is
prohibited and may be unlawful. If you have received this communication
in error, please immediately notify the sender by reply e-mail and
all copies of the communication and any attachments.