Обсуждение: 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@postgreSQL.org
[SMTP:owner-pgsql-general@postgreSQL.org]
    Sent:    Sunday, April 25, 1999 3:40 PM
    To:    pgsql-general@postgreSQL.org
    Subject:    [GENERAL] From: gorman@acheron.franken.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@acheron.franken.de
    Regensburg   ; Germany

> 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

Oh, thanks a lot. Yes this fixed my trouble. I think this is a problem in
the create user and/or alter user command. Because this command imho has
to enter the group-values in the pg_group table.

Ok, now I now how to make the trick

Thanks for your very fast help to this problem.


--
Bye
    Ernst
----
Ernst Lehmann                                    lehmann@acheron.franken.de
Regensburg   ; Germany