Rob Biedenharn wrote:

> I thought perhaps there was an option to request a read-only
> connection, but even in the low-level MySQL driver doesn't appear to
> have such a thing.  Could you connect with a user that is only GRANTed
> read-only access to the tables (or the schema, really)?  'SELECT' (and
> perhaps 'LOCK TABLE') seems to be a minimum.[1] If you try it, please
> let the list know how it goes.
> 
> -Rob

Rob:

Based on your most excellent suggestions, here you go:

http://www.ruby-forum.com/topic/213137

(short form: create a database user with readonly privileges, create an 
AR subclass that uses a connection through that user.  works like a 
champ.)

- ff
-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to