IHashedPasswords.ExcludeAdmin

Fore Syntax

ExcludeAdmin: Boolean;

Fore.NET Syntax

ExcludeAdmin: Boolean;

Description

The ExcludeAdmin property determines whether the hashing of the administrator password is disabled. The administrator (ADMIN) means the scheme owner. If the value is True then the password of the administrator is not hashed, if the value is False then the encryption is applied to the password of the administrator. By default this property is set to False.

Cancel of the administrator password hashing can be required when:

To use password of administrator while connecting to database with TOAD, PlsqlDev. For example, to create a user on DBMS level.
To specify password of administrator in connection of a thin client (web.config).

Fore Example

Sub UserProc;
Var
    MB: IMetabase;
    MBSecurity: IMetabaseSecurity;
    MBPolicy: IMetabasePolicy;
    MBPasswordPolicy: IMetabasePasswordPolicy;
    HPass: IHashedPasswords;
Begin
    Mb := MetabaseClass.Active;
    MBSecurity := MB.Security;
    MBPolicy := MBSecurity.Policy;
    MBPasswordPolicy := MBPolicy.PasswordPolicy;
    HPass := MBPasswordPolicy.HashedPasswords;
    HPass.IsON := True;
    HPass.ExcludeAdmin := True;
    MBSecurity.Apply;
End Sub UserProc;

After executing the example the password hashing will be enabled and the admin password is not hashed.

Fore.NET Example

Imports Prognoz.Platform.Interop.Metabase;

Public Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    MBSecurity: IMetabaseSecurity;
    MBPolicy: IMetabasePolicy;
    MBPasswordPolicy: IMetabasePasswordPolicy;
    HPass: IHashedPasswords;
Begin
    MB := Params.Metabase;
    MBSecurity := MB.Security;
    MBPolicy := MBSecurity.Policy;
    MBPasswordPolicy := MBPolicy.PasswordPolicy;
    HPass := MBPasswordPolicy.HashedPasswords;
    HPass.IsON := True;
    HPass.ExcludeAdmin := True;
    MBSecurity.Apply();
End Sub;

After executing the example the password hashing will be enabled and the admin password is not hashed.