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 Implementing 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