Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id DCDF12E0047 for ; Tue, 15 Apr 2008 09:08:20 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 16910-01 for ; Tue, 15 Apr 2008 09:07:41 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.225]) by developer.postgresql.org (Postfix) with ESMTP id D36B62E0030 for ; Tue, 15 Apr 2008 09:07:48 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 76so1037360wra.10 for ; Tue, 15 Apr 2008 05:07:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=8FGcPX+NL/Oq0fqduQA68MWwFGTfpq0RLAvuzhS5H1g=; b=p8VgXLqY9sD4WWxwJS4xTbvNz/jDsTb212FT+Ow5XQi/rvDWKWa9HHR3Q2FVBYBbO5Vg4G2ieHB02ftr7suFNPsLzt71Ch7TnuNH+qXyyQO8AmIqxk92O0elP2wNHH8qxijR+x/5o2QJcmApTJ2CD+0yJpmiPVgFOtcgTa/V/dU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=BrcTb9t4xjwAk6Ds/6Y90ipOvpcJWpb8/pDTuVFEDRTaYpsNmmvdX4gm1N1gqHzXOnOa4KoH8pRkGHHvjUDDDjdjtPbNUE9Cf6b7VDkHSjPtBadlfeiMH94HuiEubsLzcoTC4irhzrDZXwpJQF7TLAr6LsVLNJVDSTmkWCtJH3k= Received: by 10.143.16.9 with SMTP id t9mr2216589wfi.107.1208261264738; Tue, 15 Apr 2008 05:07:44 -0700 (PDT) Received: by 10.142.143.6 with HTTP; Tue, 15 Apr 2008 05:07:44 -0700 (PDT) Message-ID: Date: Tue, 15 Apr 2008 16:07:44 +0400 From: "Dmitry Shubin" To: pgsql-admin@postgresql.org Subject: postgres 8.1 usermanagement problem MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_42798_29319207.1208261264708" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200804/141 X-Sequence-Number: 28905 ------=_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.

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--