Toad Data Studio 1.0 - User Guide

Alter Authentication

Note: This feature is available in the Toad Data Studio Professional edition only and requires access to a Toad Intelligence Central server.

You can use the Alter Authentication dialog to perform the following tasks:

• To set your personal Authentication key (views)—The first time you attempt to access a view that was published with a personal key, Toad prompts you for authentication credentials. You must create an Authentication key by providing your user name and password to the remote data source.
• To change your personal Authentication key password—If your password changed for a remote data source, you must also change the password in your Authentication key.

• To change Shared key password—If the password changed for the shared account in the remote data source, you must also change the password for the Shared key.

  Note: The owner of an object and users with Manage privileges can modify a data object's Shared (public) key.

• To change authentication from personal to Shared (views)—You can change the type of key applied to a view from personal to Shared. A view can have only one type of key applied at a time.

  Note: The owner of an object and users with Manage privileges can change the type of Authentication key.

• To change authentication from Shared to personal (views)—You can change the type of key applied to a view from Shared to personal. A view can have only one type of key applied at a time.

  Note: The owner of an object and users with Manage privileges can change the type of Authentication key.

To set your personal Authentication key

1. In the Object Explorer, select the object you want to access. Then click .
   • Or you can right-click the object and select Operations | Set/Change Authentication.
2. In the Alter Authentication dialog, if the object is a cross-connection query, select the first data source to authenticate.

3. Enter your user name and password for the remote data source. If the object currently has a Shared key, the information for the default account is already entered.

   Notes:

   • For Google Analytics connections, sign in to your account. Click Accept on the authorization page. See Create Google Analytics Connections for more information.
   • For Salesforce corporate credentials connections, log in using your corporate credentials. Click Allow on the consent page. See Create Salesforce Connections for more information.
4. Apply this to other view objects in the same datasource that need authentication—Select this option to apply this to other views sourced from this data source with a personal key that also require authentication.
5. If the object is a cross-connection query, perform the previous steps for each data source to authenticate.
6. Click Execute.

To change a personal or Shared key password

1. In the Object Explorer, select an object and click .
2. In the Alter Authentication dialog, enter the new password.

3. Apply this to other view objects in the same datasource that need authentication—(Personal key only) If your password changed for a remote data source, you must also change the password in your personal authentication keys. If you are using the Alter Authentication dialog to change a personal authentication key password, select this option to apply the change to all applicable views.

(Views) To change authentication from personal to Shared

1. In the Object Explorer, select a view and click .

2. In the Alter Authentication dialog, select Share authentication.

   Notes:

   • You must have Manage privileges to the object before you can change the type of Authentication.
   • A view can have only one type of key at a time. When you apply a Shared key, all personal keys are dropped from the object.

(Views) To change authentication from Shared to personal

1. In the Object Explorer, select a view and click .

2. In the Alter Authentication dialog, clear the Share authentication check box.

   Notes:

   • You must have Manage privileges to the object before you can change the type of Authentication.
   • A view can have only one type of key at a time. When you apply a personal key, the shared key is dropped from the object.

Note: To learn more about authentication keys in TIC, see User Authentication in Intelligence Central.

Related Topics

User Authentication in Intelligence Central