CLIENT_AUTH

Provides information about the client authentication methods that you created.

Column Name Data Type Description 
AUTH_OID

INTEGER

 Unique identifier for the authentication method. 
AUTH_NAME

VARCHAR

Name that you gave to the authentication method.

 
IS_AUTH_ENABLED

BOOLEAN

Indicates whether you enabled the authentication method.

 
AUTH_HOST_TYPE

VARCHAR

The authentication host type, one of the following:

  • LOCAL
  • HOST
  • HOSTSSL
  • HOSTNOSSL 
AUTH_HOST_ADDRESS

VARCHAR

If AUTH_HOST_TYPE is HOST, AUTH_HOST_ADDRESS is the IP address (or address range) of the remote host. 

AUTH_METHOD

VARCHAR

Authentication method to be used.

Valid values:

  • IDENT
  • GSS
  • HASH
  • LDAP
  • REJECT
  • TLS
  • TRUST 
AUTH_PARAMETERS

VARCHAR

The parameter names and values assigned to the authentication method.

Examples

This example shows how to get information about each client authentication method that you created: 

=> SELECT auth_name, is_auth_enabled, auth_host_type, auth_host_address,
          auth_method FROM CLIENT_AUTH;                     
   auth_name   | is_auth_enabled | auth_host_type | auth_host_address   | auth_method 
---------------+-----------------+----------------+---------------------+-------------
 v_ident       | True            | LOCAL          |                     | IDENT  
 v_gss         | True            | HOST           | 0.0.0.0/0           | GSS
 v_trust       | False           | LOCAL          |                     | TRUST
 v_ldap        | True            | HOST           | 10.19.133.123/      | LDAP
 RejectNoSSL   | True            | HOSTNOSSL      | 0.0.0.0/0           | REJECT
 RejectWithSSL | True            | HOSTSSL        | 0.0.0.0/0           | REJECT
 v_hash        | False           | LOCAL          |                     | HASH    
 v_tls         | True            | HOSTSSL        | 1.1.1.1/0           | TLS
 v_trust       | True            | HOSTSSL        | 2001:db8:ab:123/128 | TLS

(9 rows)