LOGIN_FAILURES

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 in the Administrator's Guide 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