RE: [GENERAL] From: gorman@acheron.franken.de

This should do the trick:

update pg_group set grolist = '{uid1, uis2, uid3}' where grosysid = 1;
update pg_group set grolist = '{uid4, uis5, uid6}' where grosysid = 2;

where uid1,uid2,uid3 is pg_user.Usesysid for each user in group 1 and
uid4,uid5,uid6 is pg_user.Usesysid for each user in group 2 and

-----Original Message-----
From: owner-pgsql-general(at)postgreSQL(dot)org
[SMTP:owner-pgsql-general(at)postgreSQL(dot)org]
Sent: Sunday, April 25, 1999 3:40 PM
To: pgsql-general(at)postgreSQL(dot)org
Subject: [GENERAL] From: gorman(at)acheron(dot)franken(dot)de

Hello,

I am interested in the status of the Groups implementation in
PostgreSQL.

Currently I am using the 6.42 release and I have the problem, that I
can
not grant access to groups. I searched the mailinglists for this
problem,
but with no result. I read carefully the changes list for the
6.5beta
release, but there was nothing mentioned too.

Now, can anybody tell me, if the group-system in pgsql (6.42 or 6.5)

works, and if it works, please tell me how. And if it is not
working, can
anybody out there tell me, when it will be working in the future ?

Here is what I tried:

insert into pg_group values ('dbadmin','1');
create user test with password test123 in group dbadmin;
create table bezeichner.....
grant all on bezeichner to group dbadmin;

Login as user test;

select * from bezeichner;
NOTICE: in_group: group 0 not found
NOTICE: in_group: group 1 not found
NOTICE: in_group: group 96 not found
ERROR: bezeichner: Permission denied.

Am I stupid ? Am I doing something wrong ? Or is the group mechanism
still
broken.

Thank you very much for your help....

--
Bye
Ernst
----
Ernst Lehmann
lehmann(at)acheron(dot)franken(dot)de
Regensburg ; Germany