CREATE AUTHENTICATION

Creates and enables an authentication method associated with users or roles. Vertica enables the authentication method automatically.

Syntax

CREATE AUTHENTICATION auth‑method‑name METHOD 'auth‑type' access‑method

Parameters

Name Description
auth‑method‑name Name of the authentication method to create, where auth-method-name conforms to conventions described in Identifiers.
auth‑type

Name of the authentication method to use, one of the following:

  • gss
  • ident
  • ldap
  • hash
  • reject
  • trust
  • tls
access‑method

The access method the client uses to connect, specified in one of the following ways:

  • LOCAL

    Matches connection attempts made using local domain sockets.

  • HOST [ TLS | NO TLS ] 'host-ip-address'

    Matches connection attempts made using TCP/IP, where host-ip-address can be an IPv4 or IPv6 address. You can qualify HOST with one of the following options

    • TLS (default): Match an SSL/TLS-wrapped TCP socket.
    • NO TLS: Match a plain (non-SSL/TLS) socket only.

Privileges

DBADMIN

Examples

See Creating Authentication Records.

See Also