Providing Security Parameters When Registering Datasources

From DBArtisan
Jump to: navigation, search

Go Up to Manually Registering or Editing Datasources

The Datasource Registration Wizard’s Security Parameters panel lets you provide user credentials and specify other DBMS-specific security settings. The following table describes these settings and their DBMS availability:

Option Description
User ID The User ID that DBArtisan will use to connect to the datasource.
Password The password associated with the User ID.
Connect As (Oracle only) When relevant, choose the appropriate user/administrator level: NORMAL, SYSASM, SYSDBA, or SYSOPER.
Domain (SQL Server only) Identify the domain if the user has restricted access.
Auto connect? Spares the user from reentering the password every time you connect. On individual computers, auto connect can be disabled by administrators. For details, see Locking Down Features Using the Registry.
Omit User ID and Password (Generic JDBC and Generic ODBC only) If selected, no user ID are password are passed when connecting to the datasource.
Connect using Windows Authentication or Connect using OS Authentication (IBM DB2 for Windows, Unix, and Linux, MySQL, Oracle, SQL Server only) Login to the server is verified using Windows authentication.
Connect using Kerberos Authentication (Sybase ASE only) If selected, login to the server is verified using Kerberos authentication. NOTE: This option is available only if the Use alias information in the SQL.INI file/Sybase Server option on the Connection Information tab is selected. For details, see Data Editor Options.

For more general information on registering datasources, see Manually Registering or Editing Datasources.

Retrieved from "https://docwiki.embarcadero.com/DBArtisan/188/e/index.php?title=Providing_Security_Parameters_When_Registering_Datasources&oldid=6645"