Thread: postgres user with password read-only user without?
Is there a way to configure authentication so that some users require a password and other users don't? Ted
On 01/12/2016 09:41 AM, Ted Toth wrote: > Is there a way to configure authentication so that some users require > a password and other users don't? Yes, see: http://www.postgresql.org/docs/9.4/interactive/auth-pg-hba-conf.html "user Specifies which database user name(s) this record matches. The value all specifies that it matches all users. Otherwise, this is either the name of a specific database user, or a group name preceded by +. (Recall that there is no real distinction between users and groups in PostgreSQL; a + mark really means "match any of the roles that are directly or indirectly members of this role", while a name without a + mark matches only that specific role.) For this purpose, a superuser is only considered to be a member of a role if they are explicitly a member of the role, directly or indirectly, and not just by virtue of being a superuser. Multiple user names can be supplied by separating them with commas. A separate file containing user names can be specified by preceding the file name with @. " > > Ted > > -- Adrian Klaver adrian.klaver@aklaver.com
Is there a way to configure authentication so that some users require
a password and other users don't?
Yes.
David J.