> Ok, that's for testing.
> If it's for read-only data that needn't to be up to date, I could
> pump data
> in some kind of warehouse db.
> I'll also try to push them towards accessing my middle tier instead of db
> server itself.
>
> But what if they MUST have access to the live DB as I presume
> I'll be asked
> someday ?
>
> --
> Jerome

Then, as develoers, surely they will need to know what they are doing?
In any case, it sounds like you've solved 99% of it already. If now we're
talking about it happening someday, it also sounds like it won't be often.
Any long running transactions left by them will be subject to you normal
housekeeping and won' cause a problem.
Alan