CREATE AUTHENTICATION

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

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

Name Description

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

Name	Description
`auth-method-name`	Name of the authentication method to create, where `auth-method-name` conforms to conventions described in Identifiers.
`auth-type`	The authentication method type to use, one of the following: `gss` `ident` `ldap` `hash` `reject` `trust` `tls` `oauth` For details, see Supported Client Authentication Methods.
`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.

auth-type

The authentication method type to use, one of the following:

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.

DBADMIN