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.
- In Generated SQL, review the generated SQL statements.
- [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.
- Click any displayed error links below the generated SQL and correct the errors. Error messages link to the field that contains the error.
-
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.