Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group