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
- Select a table in the Schema Browser.
-
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.
- 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
- On the main toolbar, go to Database | Create | User.
- On the Object Grants tab, click Add.
- Select All or Specify.
- If you will specify privileges, select an Object Type to select the available privileges.
-
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
- Click
on the Standard toolbar to open the Schema Browser.
- Select a table, view, sequence, or procedure on the left-hand side.
-
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
- Click on the Standard toolbar to open the Schema Browser.
- Expand System Privileges.
- Right click a privilege, then click
(Configure Grantees).
- Check or clear the appropriate boxes to grant or revoke privileges to users or roles.
Look Up Foreign Keys
When you are editing table data in the Schema Browser, you can look up foreign keys and enter the associated data into the selected table.
Foreign key lookup will also work when the grid is in Read Only mode. You can disable this feature from the Toad Options | Schema Browser | Data and Grids | Enable FK Lookup.
To lookup foreign keys
- In the Schema Browser, click the Tables tab.
- Select the table you want to edit and in the details pane click the Data tab.
- Click in a column that has foreign keys. Click again to activate Editing mode. A drill down button displays.
- Click
to display the rows in the referential table.
- To enter data in appropriate columns in the data grid, select a row and click OK.
The Foreign Key Lookup Window
Within the lookup window, all foreign key constraints are included. If you want Toad to ignore disabled constraints, see Toad Options | Schema Browser | Data.
You can filter rows by typing or by directly editing the query.
To filter rows by typing
- Make sure the Filter by box in the lower left is selected.
- Put your cursor in one of the displayed columns. You can now filter by typing (if you type "ab" it will filter out rows that do not begin with "ab").
To filter rows by editing the query
- Click Edit Query.
- Edit the query within the editing window.
- Specify variables by clicking the Variable button and entering variable information.
- Check that your query syntax is accurate by clicking the Check button.
- Click OK to run your new query and filter the lookup grid.
