Do we have password less authentication in postgresql?

Question

PostgreSQL (English)

zorrroooo

Do we have password less authentication in postgresql?

#programming #russian

0

14.08.2024

1 ответов

12 просмотров

Sergey Gr · Accepted Answer

auth-method Specifies the authentication method to use when a connection matches this record. The possible choices are summarized here; details are in Section 21.3. All the options are lower case and treated case sensitively, so even acronyms like ldap must be specified as lower case. trust Allow the connection unconditionally. This method allows anyone that can connect to the PostgreSQL database server to login as any PostgreSQL user they wish, without the need for a password or any other authentication. See Section 21.4 for details. reject Reject the connection unconditionally. This is useful for “filtering out” certain hosts from a group, for example a reject line could block a specific host from connecting, while a later line allows the remaining hosts in a specific network to connect. scram-sha-256 Perform SCRAM-SHA-256 authentication to verify the user's password. See Section 21.5 for details. md5 Perform SCRAM-SHA-256 or MD5 authentication to verify the user's password. See Section 21.5 for details. password Require the client to supply an unencrypted password for authentication. Since the password is sent in clear text over the network, this should not be used on untrusted networks. See Section 21.5 for details. gss Use GSSAPI to authenticate the user. This is only available for TCP/IP connections. See Section 21.6 for details. It can be used in conjunction with GSSAPI encryption. sspi Use SSPI to authenticate the user. This is only available on Windows. See Section 21.7 for details. ident Obtain the operating system user name of the client by contacting the ident server on the client and check if it matches the requested database user name. Ident authentication can only be used on TCP/IP connections. When specified for local connections, peer authentication will be used instead. See Section 21.8 for details. peer Obtain the client's operating system user name from the operating system and check if it matches the requested database user name. This is only available for local connections. See Section 21.9 for details. ldap Authenticate using an LDAP server. See Section 21.10 for details. radius Authenticate using a RADIUS server. See Section 21.11 for details. cert Authenticate using SSL client certificates. See Section 21.12 for details. pam Authenticate using the Pluggable Authentication Modules (PAM) service provided by the operating system. See Section 21.13 for details. bsd Authenticate using the BSD Authentication service provided by the operating system. See Section 21.14 for details.

169 похожих чатов

Do we have password less authentication in postgresql?

1 ответов

Похожие вопросы