Re: How2 Toggle Read-Only SQL Access?

>We have a cheap informix clone (infoflex/sqlflex) on which >we need to take a snapshot. We'd like to allow continuous >selects (read-only) while disabling any state-changing >queries (select/update/etc) so we can create a snapshot. I >can imagine doing this via priviledge granting/revoking. > >How is this typically done among the DBA-savvy? At a guess (and using pseudo-code) FOREACH table FOREACH USER (including PUBLIC) REVOKE ALL ON table FROM user GRANT SELECT ON table TO user END FOREACH END FOREACH Remember to REVOKE any DBA-type privileges which may supersede table-level access. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com