That's a creative solution -- though I don't know the OP's full use case; if he wants to access most or all of his tables in RO mode, that could get tedious and hard to maintain.
Another might be to run a pair of DBs master/slave streaming replication setup, which usually automatically protects against writes to the slave. Then just connect to the slave. I did a quick search through the Opening Databases doc (http://sequel.jeremyevans.net/rdoc/files/doc/opening_databases_rdoc.html) and RDoc for the Sequel::Database object and didn't see any general options along those lines (except when using SQLite). However, you can also run arbitrary SQL, so you might want to check your database's docs for modes you can set. For example, I'm using MySQL, and I set some modes when I first connect. -ofer On Sunday, October 18, 2015 at 5:39:47 AM UTC-4, Christian MICHON wrote: > > You should instead create views on your SQL database and access only these > views through sequel. > On Oct 18, 2015 5:24 AM, "Jeff" <[email protected] <javascript:>> wrote: > >> I actually mean Sequel.connect(...), not connection. >> >> On Saturday, October 17, 2015 at 8:22:55 PM UTC-7, Jeff wrote: >>> >>> Is there an option in Sequel.connection (or another Sequel method) to >>> only allow read-only operations on the database, even if the user's >>> permissions would allow more? Just want to enforce more safety if possible. >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "sequel-talk" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at http://groups.google.com/group/sequel-talk. >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
