IMetabase.GetConnectedUsers

Syntax

GetConnectedUsers: IConnectedUsersInfo;

GetConnectedUsers(): Prognoz.Platform.Interop.Metabase.IConnectedUsersInfo;

Description

The GetConnectedUsers method enables getting information about the users that are connected to the repository.

NOTE. The Oracle server should have the Select grant on the V_$SESSION view for the user, that performs viewing or disconnecting of the users that are connected to the repository.

Example

To execute the example, add a link to the Metabase system assembly.

Sub UserProc;
Var
    MB: IMetabase;
    Users: IConnectedUsersInfo;
    User: IConnectedUserInfo;
Begin
    MB := MetabaseClass.Active;
    Users := MB.GetConnectedUsers;
    For Each User In Users Do
        Debug.WriteLine("Station: " + User.HostName + "; MAC address: " + User.NETAddress);
        Debug.WriteLine("DBMS user: " + User.UserOsName + "; OS user: " +
        User.UserOsName);
    End For;
End Sub UserProc;
Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Users: IConnectedUsersInfo;
    User: IConnectedUserInfo;
Begin
    MB := Params.Metabase;
    Users := MB.GetConnectedUsers();
    For Each User In Users Do
        System.Diagnostics.Debug.WriteLine("Station: " + User.HostName + "; MAC address: " + User.NETAddress);
        System.Diagnostics.Debug.WriteLine("DBMS user: " + User.UserOsName + "; OS user: " +
        User.UserOsName);
    End For;
End Sub;

After executing the example information about all users, connected to the current repository, is displayed in a development environment console.

See also:

IMetabase