| From: | Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | "J(dot) Roeleveld" <j(dot)roeleveld(at)softhome(dot)net> |
| Cc: | pgsql-list <pgsql-general(at)hub(dot)org> |
| Subject: | Re: [GENERAL] adding users to a group |
| Date: | 1999-11-26 10:38:14 |
| Message-ID: | Pine.LNX.3.96.991126111746.21790A-100000@ara.zf.jcu.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 26 Nov 1999, J. Roeleveld wrote:
> Hi,
>
> how can I add existing users to a group?
Example (add user 'gogo' to group 'mygr'):
ALTER USER gogo WITH PASSWORD "QwEr" IN GOUP mygr;
SELECT * FROM pg_user;
-----> see usesysid for 'gogo'
UPDATE pg_group SET grolist='{1000}' WHERE groname='mygr';
------> where 1000 is usesysid for 'gogo'
(for more users in one group: '{1000,1001, .. }'
It is a little terrible, because this is incomplete in the PgSQL. (All it
is probably job for a ALTER/CREATE USER, but in the current PgSQL still
not). In version 7.0?
Karel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Joao Lopes Garcia | 1999-11-26 11:31:08 | Re: [GENERAL] Postgres on Ultrasparc |
| Previous Message | J. Roeleveld | 1999-11-26 10:14:34 | adding users to a group |