pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedcreate a new user in a group
2+ messages / 2 participants
[nested] [flat]
* create a new user in a group
@ 1998-09-16 12:33 maloune <fjay@cur-archamps.fr>
0 siblings, 1 reply; 2+ messages in thread
From: maloune @ 1998-09-16 12:33 UTC (permalink / raw)
To: pgsql-sql
i'd know how create a new user in a group, because when i do this
request
create user qwe in group this_group, i ont know where the group
information
are stored. i don't see their in pg_user or pg_group.
thanks.
--
a+
maloune
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] create a new user in a group
@ 1998-09-16 13:35 Sferacarta Software <sferac@bo.nettuno.it>
parent: maloune <fjay@cur-archamps.fr>
0 siblings, 0 replies; 2+ messages in thread
From: Sferacarta Software @ 1998-09-16 13:35 UTC (permalink / raw)
To: pgsql-sql@postgresql.org, maloune <fjay@cur-archamps.fr>
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'
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-09-16 13:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-09-16 12:33 create a new user in a group maloune <fjay@cur-archamps.fr>
1998-09-16 13:35 ` Sferacarta Software <sferac@bo.nettuno.it>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox