GET_USER_ACCOUNTS¶

Description

The stored procedure GET_USER_ACCOUNTS returns information about the user accounts created in Virtual DataPort. Each row represents an user account.

It does not return information about accounts created in external systems such as the accounts of users that are registered in the Active Directory or the Identity Provider of your organization.

Syntax

GET_USER_ACCOUNTS ()

The procedure returns these fields:

• login: name of the user account.

• is_locked: the value is “true” if the account is locked.

• last_password_modification_date: date when the password account was changed.

Privileges Required

Only administrator users are able to execute this procedure.

Examples

Example 1

SELECT *
FROM GET_USER_ACCOUNTS()