On Mon, Oct 17, 2005 at 06:11:53PM +0200, Gert wrote:
> Tim Bunce wrote:
>
> > On Fri, Oct 14, 2005 at 05:15:36PM +0200, Gert wrote:
>
> >> is it possible to switch a dbi-connection between read-only and writable?
> >
> > It's not a standard part of the DBI API, but it is possible with some
>
> Hmm, ok. If it is not a standard feature I can only use it while developing
> for debugging.
No, it just means that no database-independant API has been defined
so you'll need to use database-specific code.
> > drivers. Knowing which driver you're using might help us...
>
> It is mysql and perhaps Oracle.
Umm, now I come to look at it I see that mysql's "SET READ_ONLY=1"
command only works at the global level ("SET GLOBAL READ_ONLY=1")
and that's probably not what you want. I've no time to dig further.
Anyone know how a connection can be set to read-only in MySQL and/or Oracle?
Tim.
