X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CEA9C9DC9CD for ; Tue, 20 Dec 2005 21:51:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09878-02 for ; Tue, 20 Dec 2005 21:52:01 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 44DE59DC835 for ; Tue, 20 Dec 2005 21:51:56 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id jBL1prhw071326 for ; Wed, 21 Dec 2005 01:51:53 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id jBL1gEp9038282 for pgsql-admin@postgresql.org; Wed, 21 Dec 2005 01:42:14 GMT (envelope-from news) From: ljb X-Newsgroups: pgsql.admin Subject: Users + Groups = Roles, duplicate name issue Date: Wed, 21 Dec 2005 01:42:14 +0000 (UTC) Organization: Hub.Org Networking Services Lines: 19 Message-ID: X-Complaints-To: usenet@news.hub.org User-Agent: slrn/0.9.8.1 (Linux) To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-1.44 required=5 tests=[ALL_TRUSTED=-1.44] X-Spam-Score: -1.44 X-Spam-Level: X-Archive-Number: 200512/229 X-Sequence-Number: 19949 I loaded a 7.4.x dump into a new 8.1.1 database and found out what happens if you had the same name as both a user and a group. You can get users with more rights than they had before. I guess it is too late, but perhaps a mention in the release text would have been a good idea. Advise people to rename any group which has the same name as a user. For example, if at 7.4.x I have: Group: Is granted all rights to table: test test_data acct money_data Username: Member of group: And therefore gets all rights to table: ljb test test_data test acct money_data After loading the dump into 8.1.1, the test user and test group get merged into a single role, so the test user gets granted all rights to the test_data table. In addition, 'ljb' now effectively is a member of the 'acct' group (via the test role), so is granted all rights to the money_data table.