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 CABB711F68FF for ; Tue, 4 Apr 2006 15:26:05 -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 91994-05 for ; Tue, 4 Apr 2006 15:25:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by postgresql.org (Postfix) with ESMTP id AC33811F6785 for ; Tue, 4 Apr 2006 15:25:36 -0300 (ADT) Received: (from root@localhost) by bruner.coe.tamu.edu (8.13.1/8.13.1) id k34HnMmr008028 for pgsql-admin@postgresql.org; Tue, 4 Apr 2006 12:49:22 -0500 Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p1+Sun/8.12.11) with ESMTP id k34IMAj10512 for ; Tue, 4 Apr 2006 13:22:11 -0500 (CDT) Date: Tue, 4 Apr 2006 13:22:10 -0500 (CDT) From: "Ben K." To: pgsql-admin@postgresql.org Subject: log connections to database Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by AMaViS 0.3.12 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.109 required=5 tests=[AWL=0.109] X-Spam-Score: 0.109 X-Spam-Level: X-Archive-Number: 200604/44 X-Sequence-Number: 21213 Sorry if these are basic questions. It's postgres 8.1 on unix. 1. logging to database I'd like to log connection authentication info into one of the databases, (it's ok to be on the same server as production server), but the logging configuration in postgresql.conf doesn't seem to cover this scenario. 2. checking for permissions Also, is there a way to get the list of objects a user has any permission on? If not, other than using aclcontains, is there some type I can cast relacl to get text to grep from? aclcontains doesn't seem to allow regex. 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 I couldn't see this from 8.0. Regards, Ben K. Developer http://benix.tamu.edu