The Connect Through Rights dialog enables you to grant, revoke, and display connect through privileges on trusted database users in its two tabs. Access this option by right-clicking a user in the Data Source Explorer and selecting .
Grant/Revoke Tab
Use this tab to select the trusted database users for which to set connect through rights.
Tabs | Description |
---|---|
Trusted User | Select the database user that you want proxy users to connect through. |
Trust Only | Check to grant connect through with trust-only option. |
Grant | Grant connect through privileges to application or permanent proxy users.
|
Revoke | Revoke connect through privileges to an application or permanent proxy users. |
Display | Display the current connect through privileges for the selected trusted user. |
SQL Preview
Use the SQL Preview tab to preview the generated SQL statements submitted when you click Grant or Revoke. The generated SQL updates whenever you move privilege items to the To be granted or To be revoked list. You can save the SQL to a project by using the Save SQL option in the SQL Preview tab.