Re: users & groups - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: users & groups
Date
Msg-id Pine.LNX.4.21.0006172016530.348-100000@localhost.localdomain
Whole thread Raw
In response to users & groups  (R D <mrk279@yahoo.com>)
List pgsql-admin
R D writes:

>   1. If I'm using different password files for each
> database can I grant or revoke privileges to this
> users without creating the same users in pg_user
> table?

No, you always have to use CREATE USER. Btw., I think we're pondering
removing the secondary password file feature sometime; would you care to
explain why you think you need it?

>   2. How can I add a user in more than one GROUP?

ALTER GROUP foo ADD USER bar;
ALTER GROUP foo2 ADD USER bar;

> How can I add an existing user to a new group?

CREATE GROUP foo WITH USER bar1, bar2;

> How can I remove a user from some group?

ALTER GROUP foo DROP USER bar;

RTFM :)


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-admin by date:

Previous
From: "Vladimir V. Zolotych"
Date:
Subject: PGresult
Next
From: Nicolas Huillard
Date:
Subject: RE: