Installation
System Requirements
Install Toad
Specify App Data Directory Location
Install Toad Silently
Install Toad on Citrix Systems
Uninstall Toad
Configure Toad Layouts
Create Connections
Understand Toad Connections
Create Access Connections
Create Amazon Redshift Connections
Create BusinessObjects Connections
Configure DB2 Client Connections
Configure DB2 LDAP Support
Create DB2 Connections
Create Excel Connections
Create SharePoint Connections
Create Google Analytics Connections
Create Hive Connections
Create MySQL Connections
Create ODBC Connections
Configure Oracle LDAP Support
Create Oracle Connections
Create Oracle BI Connections
Create PostgreSQL ODBC Connections
Create Salesforce Connections
Create Snowflake Connections
Create SQL Server Connections
Create SSAS Connections
Create SAP Connections
Create SAP HANA Connection
Create Teradata Connections
Troubleshoot Connections
Tables in TIC
TIC tables always reflect the current data in the source table. TIC tables can be public, private, or shared with a list of users.
Note: This feature is available in the Toad Data Studio Professional edition only and requires access to a Toad Intelligence Central server.
Operations
Use the following operations (commands) from the Object Explorer toolbar or the right-click menu.
| Operation | Description |
|---|---|
|
|
Click to configure sharing (visibility) options for the selected table. Specify Sharing and Manage Privileges for Objects |
|
|
Drops the selected table. |
|
|
Locks the selected table. Lock and Unlock Objects |
|
|
Unlocks the selected table. Lock and Unlock Objects |
Manage Privileges
Users with Manage privileges can do the following (unless the object is locked):
- Lock the object
- Drop the object
- Modify the object's sharing options
- Rename the object
- (
- (Snapshot) Refresh snapshot or modify refresh schedule
- (Automation scripts) Modify schedule
- (Automation scripts) Change user account for script execution
- (Views and Automation scripts) Modify the default value for a variable
- (Data objects) Modify a shared (public) key password
- (Views) Change the type of Authentication key
- (Secured folders) Modify the folder's sharing and manage options
- (Secured folders) Rename or delete the secured folder
- (Secured folders) Create a subfolder