Read-only access to database?


#1

I have a model (Query) which I use to, of all things, query the
database. This
is to enable raw SQL access. I want to ensure that db access using this
model
is read-only. Short of checking the sql query for ‘insert’ and ‘drop’
and
‘update’, is there a more rails-like way of doing this in my
app/models/query.rb
itself?

Thanks in advance,

cal


#2

On 2/10/06, cal removed_email_address@domain.invalid wrote:

I have a model (Query) which I use to, of all things, query the database. This
is to enable raw SQL access. I want to ensure that db access using this model
is read-only. Short of checking the sql query for ‘insert’ and ‘drop’ and
‘update’, is there a more rails-like way of doing this in my app/models/query.rb
itself?

You could have it use a separate database connection that logs in as a
user with read-only access in your database.


#3

How can we use seperate db connection since there’s only 1 account per
environment? Does anyone already try this?


Tirta K. Untario


#4

Models can be set to readonly. View the docs.

Bob S.
http://www.railtie.net/