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