From: Sferacarta Software <sferac@bo.nettuno.it>
To: pgsql-sql@postgresql.org, maloune <fjay@cur-archamps.fr>
Subject: Re: [SQL] create a new user in a group
Date: Wed, 16 Sep 1998 15:35:08 +0200
Message-ID: <3649.980916@bo.nettuno.it> (raw)
References: <35FFB02F.B940A1C2@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'
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: sferac@bo.nettuno.it, fjay@cur-archamps.fr
Subject: Re: [SQL] create a new user in a group
In-Reply-To: <3649.980916@bo.nettuno.it>
References: <35FFB02F.B940A1C2@cur-archamps.fr> <3649.980916@bo.nettuno.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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