Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ej3Gc-0008PS-Qr for pgsql-docs@arkaria.postgresql.org; Tue, 06 Feb 2018 13:26:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ej3GZ-0005YS-Gg for pgsql-docs@arkaria.postgresql.org; Tue, 06 Feb 2018 13:26:31 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ej2fh-0002zw-Fy for pgsql-docs@lists.postgresql.org; Tue, 06 Feb 2018 12:48:25 +0000 Received: from mail-by2nam01on0133.outbound.protection.outlook.com ([104.47.34.133] helo=NAM01-BY2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ej2fd-0002l2-EJ for pgsql-docs@lists.postgresql.org; Tue, 06 Feb 2018 12:48:23 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=softexpertjlle.onmicrosoft.com; s=selector1-softexpertjlle-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=zAnF0vAvQJLeY40s0U310/HHr/SSYZrgax29BnX53U4=; b=YE7hXn1uZkHt0w/7TBcMXvDH9nPy9JbOQm0HdjDOSnuGDWP6QsIO/nB5zwo491DNTnkIlrP6ug/vPVcNnktvkAOwYQYwxCVpxfAj952e1ZxivXH06k6HRjarBusn4vvqMPi70iqUv+Hbb/Xpy3IPELMbbi1NPxEBQtoJvjdV7Pg= Received: from ROXPR80MB1817.lamprd80.prod.outlook.com (10.165.255.151) by ROXPR80MB1692.lamprd80.prod.outlook.com (10.165.255.14) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.20.464.11; Tue, 6 Feb 2018 12:48:17 +0000 Received: from ROXPR80MB1817.lamprd80.prod.outlook.com ([10.165.255.151]) by ROXPR80MB1817.lamprd80.prod.outlook.com ([10.165.255.151]) with mapi id 15.20.0464.016; Tue, 6 Feb 2018 12:48:17 +0000 From: =?iso-8859-1?Q?Fabio_Souza_de_S=E1_Teles?= To: "pgsql-docs@lists.postgresql.org" Subject: trigger audit logon Thread-Topic: trigger audit logon Thread-Index: AQHTn0iAKr9BgB4ViEudU++q/0piwA== Date: Tue, 6 Feb 2018 12:48:17 +0000 Message-ID: Accept-Language: pt-BR, en-US Content-Language: pt-BR X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=fabio.teles@softexpertjlle.onmicrosoft.com; x-originating-ip: [177.135.117.126] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;ROXPR80MB1692;7:yiOH10MLXnrT7aAFvbrQRQ+yG1pYibAS6TGfrtO94hu+REQxQGRfPBvzFCdcgxZQhBVChBTny4WcyoWMhYieMHE8+/D9QF4K1Qb4BVJzPQux/b3TdyK81+SsN/Z22q1DwiXNi1P64HpiY9MYOPDrDyg1/YIQXKde2+a8OqCRD8Aiwupsgwx7nnKYwG13oGBZUdwta5uorPq3F76dgp2T98vJaoZomHdTk8P3e6RzlYOSrdQvZfSar3VLiT97hhJd x-ms-exchange-antispam-srfa-diagnostics: SSOS; x-ms-office365-filtering-correlation-id: 010ed3b1-a1a3-45d5-a73a-08d56d5fe4e2 x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(4652020)(8989060)(5600026)(4604075)(3008032)(4534165)(4627221)(201703031133081)(201702281549075)(8990040)(2017052603307)(7153060)(7193020);SRVR:ROXPR80MB1692; x-ms-traffictypediagnostic: ROXPR80MB1692: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040501)(2401047)(8121501046)(5005006)(10201501046)(3231101)(2400082)(944501161)(93006095)(93001095)(3002001)(6041288)(20161123564045)(201703131423095)(201702281528075)(20161123555045)(201703061421075)(201703061406153)(20161123560045)(20161123562045)(20161123558120)(6072148)(201708071742011);SRVR:ROXPR80MB1692;BCL:0;PCL:0;RULEID:;SRVR:ROXPR80MB1692; x-forefront-prvs: 0575F81B58 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(376002)(39850400004)(346002)(396003)(39380400002)(366004)(199004)(189003)(413944005)(478600001)(558084003)(86902001)(105586002)(3280700002)(102836004)(6506007)(25786009)(3660700001)(33656002)(4743002)(106356001)(19627405001)(77096007)(2351001)(26005)(7696005)(14454004)(74316002)(86442002)(55016002)(9686003)(54896002)(97736004)(42882006)(6916009)(6606003)(99286004)(5640700003)(2906002)(2501003)(53936002)(186003)(6436002)(6456002)(81156014)(81166006)(3846002)(7736002)(6116002)(8936002)(5660300001)(64872007)(7116003)(3480700004)(68736007)(2900100001)(86362001)(66066001)(316002)(8676002)(134773001);DIR:OUT;SFP:1102;SCL:1;SRVR:ROXPR80MB1692;H:ROXPR80MB1817.lamprd80.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;A:0;MX:1;LANG:en; received-spf: None (protection.outlook.com: softexpertjlle.onmicrosoft.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: KzwqU9OSC86S0A4WMVNRq/Hh63qHHVAoiEbA9y/jqYntxry0WpNkRt1yFMtugavQkdl02YViLfMpKmvZCczjuA== spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_ROXPR80MB1817785F6F9DE06F36E50C36C7FD0ROXPR80MB1817lamp_" MIME-Version: 1.0 X-OriginatorOrg: softexpertjlle.onmicrosoft.com X-MS-Exchange-CrossTenant-Network-Message-Id: 010ed3b1-a1a3-45d5-a73a-08d56d5fe4e2 X-MS-Exchange-CrossTenant-originalarrivaltime: 06 Feb 2018 12:48:17.1704 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 24ff4a29-e5c2-4481-8e46-6901ad0b6042 X-MS-Exchange-Transport-CrossTenantHeadersStamped: ROXPR80MB1692 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_ROXPR80MB1817785F6F9DE06F36E50C36C7FD0ROXPR80MB1817lamp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear, I'm looking to create a login and logoff audit without a bank, which is the= biggest and the user that logged in, but is not an information source on t= he internet, can you help me? Thank=B4s Fabio Teles --_000_ROXPR80MB1817785F6F9DE06F36E50C36C7FD0ROXPR80MB1817lamp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Dear,

I'm looking to create a login and logoff audit wit= hout a bank, which is the biggest and the user that logged in, but is not a= n information source on the internet, can you help me?


Thank=B4s


Fabio Teles

--_000_ROXPR80MB1817785F6F9DE06F36E50C36C7FD0ROXPR80MB1817lamp_--