Providing Security Parameters When Registering Datasources

Go Up to [[Manually Registering or Editing Datasources{{#if:||{{{2}}}}}]]

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 uses 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, administrators can disable auto connect. 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.