pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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'





view thread (2+ messages)

Message-ID: <3649.980916@bo.nettuno.it>
Permalink:  ../3649.980916@bo.nettuno.it/
Also on:    postgresql.org/message-id/3649.980916@bo.nettuno.it

 · 

reply

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