Toad for Oracle, Read-Only
Toad can be made read only using the two license files: READONLY.LIC and FULLToad.LIC.
What is Toad Read Only?
Toad Read Only is a way to allow users to view data and SQL through Toad without making changes to the database.
Why use Toad Read Only?
Toad Read Only allows administrators to give their users a powerful tool without worrying about a user committing a change to a sensitive production instance.
While Toad honors privileges granted to the Oracle user, Toad Read Only will not allow the user to do anything which changes the content of the database.
Where to get Toad Read Only?
You can make any Toad installation read-only, you can use Toad Security to make selected users or roles read-only, or you can get a special read-only installation that has extra exclusions to prevent users from making changes.
How to make any Toad installation Read-Only
Using License files
Toad can be made read-only using the two license files: READONLY.LIC and FULLToad.LIC found in the installation directory where Toad is installed.
Toad.EXE only reads Toad.LIC to determine if it is full Toad or read-only. The license file contains a setting for read only database access. The network administrator can copy READONLY.LIC over the Toad.LIC on an individual workstation to make Toad read-only at that workstation. Remember, the Toad.LIC file must be in the Toad folder.
This is the least secure method of limiting Toad.
To use read only license files
Copy READONLY.LIC over the TOAD.LIC on an individual workstation.
Toad Security
Using Toad Security you can make Toad read-only to a selected user or role. This is useful if you have someone who needs to view database objects but does not have the authority to change them.
Note: This Toad Security option does not apply to the DBA module. To restrict Toad entirely, you will also need to restrict the DBA module from the appropriate users.
To make Toad read-only using Toad Security
Move the Read-only Override function from the Features Non-menu list to the Restricted features list in the Toad Security window. This makes Toad read-only to the selected user.
Toad Read Only Installation
Quest Software, Inc. can provide a read only copy of Toad. The Toad Standard Edition - READ ONLY install is a read only executable designed to prevent its users from changing the database. For this reason, it does not include Quest ScriptRunner (which lets a user write a script that can update database objects), SQLMonitor (which logs SQL calls using the OCI layer), and Server Side Install (which lets users make changes to Toad schemas).