Login filter - Vertica

This filter is an easy way to filter login packets -- it's essentially a JavaScript request filter preset with Packet types=StartupMessage.

Parameters

• Client IPs: optional. If specified, a comma-separated (or line break separated) list of IP4 or IP6 addresses or regular expressions for IP addresses. This filter will then be invoked only for login attempts from the specified IP address(es).

• Users: optional. If specified, a comma-separated (or line break separated) list of user names or regular expressions for user names. This filter will then be invoked only for login attempts from the specified users.

The context.packet object will be a StartupMessage packet.

Example

A simple-minded login filter that rejects logins from vsql:

if (context.packet.parameters["client_type"] === 'vsql') { 

    context.result.success = false;

    context.result.errorMessage = "You can't log in, sorry";

    context.result.errorCode = 12345;

    log.debug("Rejecting login from vsql client");

}