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 63A6A9DCC22 for ; Wed, 21 Dec 2005 16:31:27 -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 12393-08-2 for ; Wed, 21 Dec 2005 16:31:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from flake.decibel.org (unknown [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id E35509DCBDF for ; Wed, 21 Dec 2005 16:31:21 -0400 (AST) Received: by flake.decibel.org (Postfix, from userid 1001) id 8698639834; Wed, 21 Dec 2005 14:31:23 -0600 (CST) Date: Wed, 21 Dec 2005 14:31:23 -0600 From: "Jim C. Nasby" To: ljb Cc: pgsql-admin@postgresql.org Subject: Re: Users + Groups = Roles, duplicate name issue Message-ID: <20051221203123.GG72143@pervasive.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.0-RELEASE amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.047 required=5 tests=[AWL=0.047] X-Spam-Score: 0.047 X-Spam-Level: X-Archive-Number: 200512/253 X-Sequence-Number: 19973 Which version of pg_dump did you use to dump the old database? The recommended procedure is to use the newer version of pg_dump (ie: pg_dump from 8.1.1) to dump the old database. It's possible that the newer version of pg_dump has facilities in place to deal with this. Those facilities would obviously be missing from older versions. On Wed, Dec 21, 2005 at 01:42:14AM +0000, ljb wrote: > 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. > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461