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:
|
| 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)