As part of my learning process, I’ve been charged with putting together documentation on how to setup Toad for the rest of the users in my department.
The majority of the databases we deal with are strict Read-Only databases - they’re available for us to report against, but we cannot make any changes to them.
On the Oracle database this is controlled using the roles established for each of the users, but Toad still prompts me if I want to commit changes to this database. I’ve got the configuration marked as “Read Only” and I’ve got Auto Commit set to “No” - but it gets annoying that it keeps asking me. Is there any way to get this to stop?
Also, we have several MS SQL databases and of course Access in the mix. I have write access to some MS SQL databases, and of course there’s not really any control on Access. With MS SQL I am prompted to save my changes - but 99% of the time I’ve not actually made any changes, at least not intentionally - is there anyway to get Toad to treat this database as a strict Read-Only unless told otherwise?