IDatabaseApplicationRole.DerivedPassword

Syntax

DerivedPassword: Boolean;

Description

The DerivedPassword property determines using of derived password at creation of connection to database.

Comments

If the value is True, the password is encrypted, if the value is False, it is not. By default the property is set to True.

Example

Executing the example requires the EditBox1 and EditBox2 components of the EditBox type on the form. The scheme should have a database with the DB identifier that should use DBMS of Microsoft SQL Server type.

Sub UserProc;
Var
    MB : IMetabase;
    DbObj: IMetabaseObject;
    Db : IDatabase;
    Role : IDatabaseApplicationRole;
Begin
    MB := MetabaseClass.Active;
    DbObj := MB.ItemById("DB").Edit;
    Db := DbObj As iDatabase;
    Role := Db.Role;
    If Role.Mode=DatabaseApplicationRoleMode.Off Then
        Role.Mode := DatabaseApplicationRoleMode.On_;
        Role.DerivedPassword := False;
    End If;
    DbObj.Save;
End Sub UserProc;

After executing the example, use of application role is enabled, the application role password at connection to database is not encrypted.