PostgreSQL DBA

Roles, Authentication & Security

Question

LOGIN role versus NOLOGIN role: how should each be used?

Answer

A LOGIN role can authenticate and start sessions. A NOLOGIN role cannot connect but can own objects and carry privileges. Use LOGIN for identities and NOLOGIN roles for reusable access bundles.

This is 3 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples