Re: a role without login priviledge

From: Philip Couling <phil(at)pedal(dot)me(dot)uk>
To: tukuna patro <tukuna(dot)patro(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: a role without login priviledge
Date: 2012-02-29 14:38:25
Message-ID: 4F4E3861.2080301@pedal.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Piyush Lenka 2012-03-01 14:02:40 Can not restore when there is a primary key violation
Previous Message tukuna patro 2012-02-29 10:33:11 a role without login priviledge