Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 57BB39FB1C2 for ; Thu, 9 Nov 2006 02:59:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 80416-03 for ; Thu, 9 Nov 2006 02:59:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 6681B9F9424 for ; Thu, 9 Nov 2006 02:59:14 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 33A1E56456; Thu, 9 Nov 2006 00:59:14 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Thu, 9 Nov 2006 00:59:12 -0600 Date: Thu, 9 Nov 2006 00:59:12 -0600 From: "Jim C. Nasby" To: Kuckuck Kuckuck Cc: pgsql-admin@postgresql.org Subject: Re: Problems changing column attribute Message-ID: <20061109065911.GD90133@nasby.net> References: <20061107103654.2835.qmail@web26004.mail.ukl.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20061107103654.2835.qmail@web26004.mail.ukl.yahoo.com> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:061109:gentoopower@yahoo.de::7E/ISOeDGZxpoICB:00000000000000000 0000000000000000000000005oXJ X-Hashcash: 1:20:061109:pgsql-admin@postgresql.org::OZWjYUTGWHa9SGeh:00000000000 0000000000000000000000001UUa X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/84 X-Sequence-Number: 23611 On Tue, Nov 07, 2006 at 10:36:54AM +0000, Kuckuck Kuckuck wrote: > Hi folks, I have been breaking my head over this. > I logg in as testuser via pgadmin. > I create a table as user 'testuser' added some columns, one of them for example is name: 'testcolumn' type: varchar length: 50 > Now I'd like to change testcolumn's length to 60, as user 'testuser' I'm not allowed to change it and pgadmin tells me that I don't have the rights to change relation pg_attribute. > > If I change the length of 'testcolumn' from an admin account it works. Now I granted all priviliges for this table to user 'testuser' via the admin account, but still I cannot change the length if I log in with 'testuser'. > > Is there any chance to grant some user (in my case 'testuser') the right to change attributes, without making him superuser? Can you reproduce this using psql? If you can, please provide us a complete test case so others can look at it. If not, you'll need to post on the pgAdmin list. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)