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()