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
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.
In response to
pgsql-novice by date
|Next:||From: Piyush Lenka||Date: 2012-03-01 14:02:40|
|Subject: Can not restore when there is a primary key violation|
|Previous:||From: tukuna patro||Date: 2012-02-29 10:33:11|
|Subject: a role without login priviledge|