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 42EC011F6793 for ; Tue, 4 Apr 2006 17:02:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96306-06 for ; Tue, 4 Apr 2006 17:02:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx2.surnet.cl (mx2.surnet.cl [216.155.73.181]) by postgresql.org (Postfix) with ESMTP id 4E06811F603C for ; Tue, 4 Apr 2006 17:01:56 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx2.surnet.cl with ESMTP; 04 Apr 2006 16:01:50 -0400 X-IronPort-AV: i="4.02,198,1139194800"; d="scan'208"; a="40839525:sNHT19388596" Received: from alvh.no-ip.org (201.220.123.170) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 43A978FD00D5F551; Tue, 4 Apr 2006 16:01:50 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 0A870C2DC4F; Tue, 4 Apr 2006 16:01:50 -0400 (CLT) Date: Tue, 4 Apr 2006 16:01:49 -0400 From: Alvaro Herrera To: "Ben K." Cc: pgsql-admin@postgresql.org Subject: Re: log connections to database Message-ID: <20060404200149.GB18599@surnet.cl> Mail-Followup-To: "Ben K." , pgsql-admin@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.11+cvs20060126 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.684 required=5 tests=[AWL=-0.235, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44] X-Spam-Score: 1.684 X-Spam-Level: * X-Archive-Number: 200604/46 X-Sequence-Number: 21215 Ben K. wrote: > 3. dropping a role > > If the user is not the owner of the object, is the following an intended > behavior, or could it be some misconfiguration on my side? (In fact this > seems to give me the list of objects the user has acl on.) > > create group ddd; > grant all on atable to ddd; > \dp atable > public | atable | table | {postgres=arwdRxt/postgres,ddd=arwdRxt/postgres} > drop group ddd; > ERROR: role "ddd" cannot be dropped because some objects depend on it > DETAIL: access to table atable Yup, this is intended and new in 8.1. You need to REVOKE the privileges before being able to drop the role. In 8.2 (current development) there is a commands to drop the objects owned by the user, which additionally revokes all the privileges; and a command to "give" the objects to someone else. They didn't make the 8.1 deadline however. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support