From: | Nicolas Huillard <nhuillard(at)ghs(dot)fr> |
---|---|
To: | "'Peter Eisentraut'" <peter_e(at)gmx(dot)net>, R D <mrk279(at)yahoo(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | RE: users & groups |
Date: | 2000-06-19 08:17:34 |
Message-ID: | 01BFD9D7.9691D940@agen.int.ghs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I think all that works in 7.0, not 6.5 ? (after RTFM a few months ago)
Nicolas Huillard
-----Message d'origine-----
De: Peter Eisentraut [SMTP:peter_e(at)gmx(dot)net]
Date: dimanche 18 juin 2000 16:17
A: R D
Cc: pgsql-admin(at)postgresql(dot)org
Objet: Re: users & groups
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 vag 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
From | Date | Subject | |
---|---|---|---|
Next Message | R D | 2000-06-19 08:51:38 | Re: users & groups |
Previous Message | Nicolas Huillard | 2000-06-19 08:14:27 | RE: |