LOGIN_FAILURES

This system table lists failures for each failed login attempt.

This system table lists failures for each failed login attempt. This information helps you determine if a user is having difficulty getting into the database or identify a possible intrusion attempt.

Column Name	Data Type	Description
`LOGIN_TIMESTAMP`	TIMESTAMPTZ	Time when Vertica recorded the login.
`DATABASE_NAME`	VARCHAR	The name of the database for the login attempt.
`NODE_NAME`	VARCHAR	Name of the node that is reporting the requested information.
`USER_NAME`	VARCHAR	Name of the user whose login failed at the time Vertica recorded the session.
`CLIENT_HOSTNAME`	VARCHAR	Host name and port of the TCP socket from which the client connection was made. NULL if the session is internal.
`CLIENT_PID`	INTEGER	Identifier of the client process that issued this connection. In some cases, the client process is on a different machine from the server.
`CLIENT_VERSION`	VARCHAR	Unused.
`CLIENT_OS_USER_NAME`	VARCHAR	The name of the user that logged into, or attempted to log into, the database. This is logged even when the login attempt is unsuccessful.
`AUTHENTICATION_METHOD`	VARCHAR	Name of the authentication method used to validate the client application or user who is trying to connect to the server using the database user name provided Valid values: `Trust` `Reject` `GSS` `LDAP` `Ident` `Hash` `TLS` See Configuring client authentication for further information.
`CLIENT_AUTHENTICATION_NAME`	VARCHAR	Locally created name of the client authentication method.
`REASON`	VARCHAR	Description of login failure reason. Valid values: `INVALID USER` `ACCOUNT LOCKED` `REJECT` `FAILED` `INVALID AUTH METHOD` `INVALID DATABASE`

Privileges

Superuser