Toad Data Studio 1.1

Chat now with support

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Read-Only Installation

During installation, you can select an option to install Toad as a read-only application. This lets you query data and view objects using Toad, but all actions that can impact the database (Create, Alter, Drop, Insert, Update, etc.) are disabled or hidden. This ensures that you can use Toad without worrying about committing a change to a sensitive production instance. The following image shows an example of the differences between a typical and a read-only installation:

To install a read-only version of Toad Data Studio

During installation, select the Read-only option.

To change an existing installation to read-only

Reinstall Toad and select Read-only Install on the Install Type page.

Additional Considerations and Limitations of Read-Only Install

Review the following additional considerations/limitations before using a Toad read-only installation.

Consideration/Limitation
Additional limitations for IBM DB2 z/OS connections	When using an IBM DB2 z/OS connection in a read-only install of Toad, please note the following additional limitations: The Dependencies, Grants, and Script tabs in the Database Explorer (Viewer) are not available. The Clone Tables node/tab in the Object Explorer is not available. The user does not have SQL access to SYS<xxx>AUTH tables.

Consideration/Limitation

Additional limitations for IBM DB2 z/OS connections

When using an IBM DB2 z/OS connection in a read-only install of Toad, please note the following additional limitations:

The Dependencies, Grants, and Script tabs in the Database Explorer (Viewer) are not available.
The Clone Tables node/tab in the Object Explorer is not available.
The user does not have SQL access to SYS<xxx>AUTH tables.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Studio 1.1 - User Guide

Read-Only Installation

Additional Considerations and Limitations of Read-Only Install