Обсуждение: a role without login priviledge

what is the need of creating a role without login priviledge s in  postgresql  ?

On 29/02/2012 10:33, tukuna patro wrote:
> what is the need of creating a role without login priviledge s in
>  postgresql  ?
> Without logging in what can a role may do ?

In PostgreSQL groups and users are all just roles.  So a role that can't
log in is basically just a group used to make assigning permissions more
manageable. See:
http://www.postgresql.org/docs/current/static/role-membership.html

Also revoking login from a user is a quick and effective way to
temporarily ban a user from the DB without dropping the role entirely.

Regards