SQL Preview Tab - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
sbq1486739977986.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
The SQL Preview tab displays the generated SQL GRANT and REVOKE statements required to create grant and revoke privileges on trusted users. The text in the Generated SQL region of the tab is red if the definition is incomplete or contains an error.
  1. In Generated SQL, review the generated SQL statements.
  2. [Optional] Click the Grant/Revoke tab to change the granted or revoked privileges defined in the SQL statement. Any changes you make automatically generate new SQL for your review.
  3. Click any displayed error links below the generated SQL and correct the errors. Error messages link to the field that contains the error.
  4. Choose one of the following:
    Option Description
    Save SQL Saves the SQL statement to an SQL file in an existing project in your workspace. The Save SQL dialog opens. Select a project folder and type a file name, then click OK.
    Show in Editor Displays the SQL statement in the SQL Editor. The Connect Through Rights dialog is not closed.