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