CLIENT_AUTH_PARAMS

Provides information about client authentication methods that have parameter values assigned.

Column Name Data Type Description
AUTH_OID

INTEGER

A unique identifier for the authentication method.
AUTH_NAME

VARCHAR

Name that you defined for the authentication method.

AUTH_PARAMETER_NAME

VARCHAR

Parameter name required by the authentication method. Some examples are:

  • system_users
  • binddn_prefix
  • host
AUTH_PARAMETER_VALUE VARCHAR Value of the specified parameter.

Examples

This example shows how to retrieve parameter names and values for all authentication methods that you created. The authentication methods that have parameters are:

  • v_ident
  • v_ldap
  • v_ldap1
=> SELECT * FROM CLIENT_AUTH_PARAMS; auth_oid | auth_name | auth_parameter_name | auth_parameter_value -------------------+---------------+---------------------+------------------------------ 45035996273741304 | v_ident | system_users | root 45035996273741332 | v_gss | | 45035996273741350 | v_password | | 45035996273741368 | v_trust | | 45035996273741388 | v_ldap | host | ldap://172.16.65.177 45035996273741388 | v_ldap | binddn_prefix | cn= 45035996273741388 | v_ldap | binddn_suffix | ,dc=qa_domain,dc=com 45035996273741406 | RejectNoSSL | | 45035996273741424 | RejectWithSSL | | 45035996273741450 | v_md5 | | 45035996273904044 | l_tls | | 45035996273906566 | v_hash | | 45035996273910432 | v_ldap1 | host | ldap://172.16.65.177 45035996273910432 | v_ldap1 | basedn | dc=qa_domain,dc=com 45035996273910432 | v_ldap1 | binddn | cn=Manager,dc=qa_domain,dc=com 45035996273910432 | v_ldap1 | bind_password | secret 45035996273910432 | v_ldap1 | search_attribute | cn (17 rows)