StarQuest Technical Documents
StarSQL Login Frequently Asked Questions
Last Update: 26 June 2008
Product: StarSQL
Version: 5.x
Article ID: SQV00SQ032
Abstract
This article answers frequently asked questions (FAQs) about using StarSQL logins.
How can I automate my StarSQL data source
login?
How can I prevent the User ID from appearing in
the StarSQL connection dialog?
How can I encrypt the User ID and Password (StarSQL 5.3x or later)?
Solution
How can I automate my StarSQL data source login?
You can automate StarSQL logins so that the user does not have to enter in a User ID and Password when making a connection. Please see StarQuest Technical Document, How to Automate StarSQL Logins for detailed instructions.
How can I prevent the User ID from appearing in the StarSQL connection dialog?
In the Expert Page of the StarSQL data source configuration, change the CacheUID parameter value to No.
The default for this value is Yes.
How can I encrypt the User ID and Password (StarSQL 5.3x or later)?
In the Security/Accounting page of the StarSQL data source configuration, check the Enable User ID/Password Encryption box and select the appropriate radio button. If you are unsure whether or not your DB2 supports encryption, consult your DBA. For more information, refer to the Configuring Security and Accounting topic in the StarSQL help.
DISCLAIMER
The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization. The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.