From: | Sferacarta Software <sferac(at)bo(dot)nettuno(dot)it> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org, maloune <fjay(at)cur-archamps(dot)fr> |
Subject: | Re: [SQL] create a new user in a group |
Date: | 1998-09-16 13:35:08 |
Message-ID: | 3649.980916@bo.nettuno.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello Maloune,
mercoledì, 16 settembre 98, you wrote:
m> i'd know how create a new user in a group, because when i do this
m> request
m> create user qwe in group this_group, i ont know where the group
m> information
m> are stored. i don't see their in pg_user or pg_group.
m> thanks.
m> --
m> a+
m> maloune
Currently, to create a GROUP you have to insert data manually into table pg_group as:
hygea=> INSERT INTO pg_group VALUES ('sfera',100);
INSERT 52704 1
hygea=> select * from pg_group;
groname|grosysid|grolist
-------+--------+-------
sfera | 100|
(1 row)
hygea=> CREATE USER miriam IN GROUP sfera;
CREATE USER
hygea=> select * from pg_group;
groname|grosysid|grolist
-------+--------+-------
sfera | 100|
(1 row)
hygea=> select usename, usesysid from pg_user;
usename |usesysid
--------+--------
postgres| 1009
miriam | 1011
(2 rows)
Jose'
From | Date | Subject | |
---|---|---|---|
Next Message | Barracuda | 1998-09-16 13:48:10 | Re: [SQL] How to Make Case InSensitive??? |
Previous Message | maloune | 1998-09-16 12:33:51 | create a new user in a group |