User management, authentication and security are all managed by PostgreSQL. Please consult PostgreSQL documentation for further detail.

https://www.postgresql.org/docs/10/static/client-authentication.html

https://www.postgresql.org/docs/10/static/user-manag.html