Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42354=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WXJri-0007XA-FL
 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Apr 2014 00:26:14 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42354=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WXJrh-0001ob-Vf
 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Apr 2014 00:26:14 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <sql-pgsql-admin@m.gmane.org>) id 1WXJrg-0001oU-Vi
 for pgsql-admin@postgresql.org; Tue, 08 Apr 2014 00:26:13 +0000
Received: from plane.gmane.org ([80.91.229.3])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <sql-pgsql-admin@m.gmane.org>) id 1WXJre-0002U6-VJ
 for pgsql-admin@postgresql.org; Tue, 08 Apr 2014 00:26:12 +0000
Received: from list by plane.gmane.org with local (Exim 4.69)
 (envelope-from <sql-pgsql-admin@m.gmane.org>) id 1WXJrd-0002ap-Vo
 for pgsql-admin@postgresql.org; Tue, 08 Apr 2014 02:26:09 +0200
Received: from cpc3-walt15-2-0-cust148.13-2.cable.virginm.net
 ([86.21.186.149])
 by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
 id 1AlnuQ-0007hv-00
 for <pgsql-admin@postgresql.org>; Tue, 08 Apr 2014 02:26:09 +0200
Received: from walterhurry by cpc3-walt15-2-0-cust148.13-2.cable.virginm.net
 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
 for <pgsql-admin@postgresql.org>; Tue, 08 Apr 2014 02:26:09 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-admin@postgresql.org
From: Walter Hurry <walterhurry@gmail.com>
Subject: Re: How to find table creation time
Date: Tue, 8 Apr 2014 00:25:57 +0000 (UTC)
Lines: 8
Message-ID: <lhvfml$456$1@ger.gmane.org>
References: 
 <CAHySzWVNoyn803AOU3fU6yzjTa1bmQ28RED_+t3MKmCV7tgCSA@mail.gmail.com>
 <5342DA72.2030103@pinpointresearch.com> <etPan.534301bf.46e87ccd.2ad6@palos>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-13
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: cpc3-walt15-2-0-cust148.13-2.cable.virginm.net
User-Agent: XPN/1.2.6 (Street Spirit ; FreeBSD)
X-Pg-Spam-Score: -1.3 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Jason Mathis wrote:

> someone ´sneaking in¡ a change. Or even think about data recovery, ´what time did you drop that production table?¡

Whaaat? You need to do a security review *now*. These possibilities indicate anarchy, and are a sure recipe for disaster. Someone has dropped a production table and you want it to be logged, or to be emailed about it?

You don't *grant* privileges to drop production tables to all and sundry.




-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin