postgres 8.1 usermanagement problem

------=_Part_42798_29319207.1208261264708
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hallo to all! I use Postgres 8.1 and i've got problem in its
usermanagement.

Here is me roles list:
nausd=# \du
List of roles
Role name | Superuser | Create role | Create DB | Connections | Member of
-------------+-----------+-------------+-----------+-------------+--------------
dss0 | yes | yes | yes | no limit |
georgyd | no | no | no | no limit | {nausd_read}
joe | no | no | no | no limit |
nausd | no | no | no | no limit |
nausd_read | no | no | no | no limit |
postgres | yes | yes | yes | no limit |
sagach_user | no | no | no | no limit |
system | no | no | no | no limit |
testgrp | no | no | no | no limit |
testus | no | no | no | no limit | {testgrp}
ttest | no | no | no | no limit |
(11 rows)

testus - user is a member of the testgrp

Then I changed permission in table tbl_a_a_container from database nausd:

nausd=# \z
Access privileges for database "nausd"
Schema | Name | Type | Access privileges
--------+--------------------------------+----------+----------------------------------------------------------------
public | tbl_a_a_container | table |
{nausd=arwdRxt/nausd,nausd_read=r/nausd,testgrp=arwdRxt/nausd}

So, we can see all rights for group testgrp and correspondingly for
testus.

But when I logging to databes nausd with user testus and try to select
from
tbl_a_a_container - I got error: permission denied for relation
tbl_a_a_container

What's wrong?

------=_Part_42798_29319207.1208261264708
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hallo to all! I use Postgres 8.1 and i've got problem in its
usermanagement.<br><br>Here is me roles list:<br>nausd=# \du<br>          
                      List of roles<br>  Role name  | Superuser | Create
role | Create DB | Connections |  Member of <br>
 
-------------+-----------+-------------+-----------+-------------+--------------<br>
dss0        | yes       | yes         | yes       | no limit    | <br>
georgyd     | no        | no          | no        | no limit    |
{nausd_read}<br>
 joe         | no        | no          | no        | no limit    | <br>
nausd       | no        | no          | no        | no limit    | <br>
nausd_read  | no        | no          | no        | no limit    | <br>
postgres    | yes       | yes         | yes       | no limit    | <br>
 sagach_user | no        | no          | no        | no limit    | <br>
system      | no        | no          | no        | no limit    | <br>
testgrp     | no        | no          | no        | no limit    | <br>
testus      | no        | no          | no        | no limit    |
{testgrp}<br>
 ttest       | no        | no          | no        | no limit    | <br>(11
rows)<br><br>testus - user is a member of the testgrp<br><br>Then I changed
permission in table tbl_a_a_container from database nausd:<br><br>nausd=#
\z<br>
                                       Access privileges for database
&quot;nausd&quot;<br> Schema |              Name              |   Type   |
                      Access privileges <br>                      
--------+--------------------------------+----------+----------------------------------------------------------------<br>
 public | tbl_a_a_container              | table    |
{nausd=arwdRxt/nausd,nausd_read=r/nausd,testgrp=arwdRxt/nausd}<br><br>So,
we can see all rights for group testgrp and correspondingly for
testus.<br><br>But when I logging to databes nausd with user testus and
try to select from tbl_a_a_container - I got error: permission denied for
relation tbl_a_a_container<br>
<br>What&#39;s wrong?<br><br>

------=_Part_42798_29319207.1208261264708--