Advanced Settings: Database

The Advanced Settings dialog box is opened by clicking the corresponding button on the Database Properties page: Advanced parameters set can be different according to the DBMS type.

Advanced settings for Oracle server:

OS Users Name Format. When the domain authentication is used, it may require to specify the user names format because the following format is used by default: DOMAIN\USER_NAME. If prefix before user names is set for the server (the OS_AUTHENT_PREFIX parameter), it must be specified in this box. To create format, you can use static text and the following tags:

$User. User name.
$Domain. Domain name.
$FullDomain. Full domain name.
$FullDomainUser. Full domain user name (includes user name and full domain name separated with the @ character).

NOTE. Tags are case-sensitive.

Format examples:

$User@$Domain.COM

In this format user name looks as follows: IVANOV@EXAMPLE.COM.

$Domain@$User

User name looks as follows: EXAMPLE@IVANOV.

$User@$FullDomain

In this format user name looks as follows: IVANOV@EXAMPLE.WORLD.COM.

$FullDomainUser

In this format user name looks as follows: IVANOV@EXAMPLE.WORLD.COM.

Advanced settings for Microsoft SQL Server:

DBMS is Case Sensitive. Selecting the checkbox enables the user to work with DBMS objects with different capitalization in their physical name.

NOTE. If the checkbox is selected, database objects will be available only on specifying their exact physical name.

File Group. If a file group, different from initial group, must be used, specify its name in the File Group field.

Specified settings are used to distribute permissions on the DBMS level and considered on connection and operations with database.

Advanced settings for Microsoft SQL Server (ODBC):

Connection String. The editor is used to specify advanced connection parameters with the use of ODBC driver.

Advanced settings for PostgreSQL server:

DBMS is Case Sensitive. Selecting the checkbox enables the user to work with DBMS objects with different capitalization in their physical name.

NOTE. If the DBMS Is Case Sensitive checkbox is selected, database objects will be available only on specifying their exact physical name.

Additional settings for the Teradata server:

OS Users Name Format. When the domain authentication is used, it may require to specify the user names format because the following format is used by default: DOMAIN\USER_NAME. If prefix before user names is set for the server (the OS_AUTHENT_PREFIX parameter), it must be specified in this box. To create format, you can use static text and the following tags:

$User. User name.
$Domain. Domain name
$FullDomain. Full domain name
$FullDomainUser. Full domain user name (includes user name and full domain name separated with the @ character).

NOTE. Tags are case-sensitive.

Format examples:

$User@$Domain.COM

In this format, user name looks as follows: IVANOV@EXAMPLE.COM.

$Domain@$User

In this format, user name looks as follows: EXAMPLE@IVANOV.

$User@$FullDomain

In this format, user name looks as follows: IVANOV@EXAMPLE.WORLD.COM.

$FullDomainUser

In this format, user name looks as follows: IVANOV@EXAMPLE.WORLD.COM.

It is possible to determine the macro that is executed on each connection regardless of the type of used DBMS. To do that select the Module/Form/Assembly/.NET Assembly in which the macro is implemented. At the same time, the list of available methods is to be formed in the Method list. Available statistic procedures with one parameter of a following type ISecurityConnection:

Class PrepareDB: Object
    Public Shared Sub OnDBConnecting(Connection: ISecurityConnection);
    Begin
        //Preparing connection
    End Sub OnDBConnecting;
End Class PrepareDB;

The procedure is executed right after connection and before of any other queries. The created connection is available in the procedure input parameter. Any advanced connection settings can be determined in this procedure.