Toad for Oracle 15.0 - Getting Started Guide

Flashback Tables (Recover Dropped Tables)

A recycle bin is available to retrieve tables and associated objects (such as indexes, constraints, and triggers) you have dropped from the database. From the Schema Browser's Recycle Bin page you can access this bin and retrieve dropped tables if necessary.

To flashback a table

1. Click on the Standard toolbar to open the Schema Browser.
2. Select the Recycle Bin in the left-hand side.
3. Select the table you want to recover from the list and click .
4. Restore the table with the original name or a new one.

View Parent/Child Datasets

When you view a table's data in the Schema Browser, you can split the window to also show child or parent tables in a new detail grid. You can also change the query for the detail grid.

To view parent/child datasets in the Schema Browser

1. Select a table in the Schema Browser.

2. Select the Data tab and click on the Data tab toolbar.

   If the table has a single foreign key, Toad automatically displays the related table. If there is more than one foreign key, click the arrow beside on the detail grid toolbar and select a table. Toad remembers your selection.

3. To edit the query in the detail grid, click on the detail grid toolbar.

View/Modify Privileges

You can assign object privileges from the Create or Alter User windows, or from the Privileges window.

To access the Add Object Privileges window

1. On the main toolbar, go to Database | Create | User.
2. On the Object Grants tab, click Add.
3. Select All or Specify.
   • If you will specify privileges, select an Object Type to select the available privileges.

4. Select an Object Type and choose objects to grant privileges on, using the arrow buttons to move those objects to the Grants grid on the right.

The Privileges window allows you to view, grant, and revoke privileges on a database object. You can view all users and their privileges. If you are not the object owner, you can only grant privileges if you have been given the "grant option."

To access the Privileges window

1. Click on the Standard toolbar to open the Schema Browser.
2. Select a table, view, sequence, or procedure on the left-hand side.

3. Click on the left-hand side toolbar. Grants are highlighted in blue and admin grants in yellow.

   Tip: If you do not see all users, make sure Hide privileges granted by other users or Hide users/roles with no privileges assigned is not selected.

Configure Grantees

From the System Privileges window you can grant or revoke selected privileges to/from a selected user. In addition, you can do the same to a selected role or roles.

To grant or revoke a privilege

1. Click on the Standard toolbar to open the Schema Browser.
2. Expand System Privileges.
3. Right click a privilege, then click (Configure Grantees).
4. Check or clear the appropriate boxes to grant or revoke privileges to users or roles.