Skip site navigation (1) Skip section navigation (2)

Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL

From: Walter Hurry <walterhurry(at)lavabit(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Date: 2012-03-14 21:15:08
Message-ID: jjr1os$dkf$1@dough.gmane.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, 14 Mar 2012 13:24:36 +0200, Khangelani Gama wrote:

> thanks, the issue we have is that we have many Linux users having root
> access into the system. So they're able to access the DB by just going
> in as "su - superusername". If this user is able to make any updates
> inside the database it might create problems. Auditors wants PostgreSQL
> to tell who updated what inside the database besides client users that
> access the database from outside using some applications. So this common
> "superusername" doesn't tell the actual person who got into the system
> and went onto make updates inside the database because they first logged
> as their linux users before as going in as postgres user called
> "superusername".

http://dl.dropbox.com/u/6106778/message.jpg



In response to

pgsql-admin by date

Next:From: Khangelani GamaDate: 2012-03-15 04:33:45
Subject: Re: Update actions (with user name) inside PostgreSQL DB - any version on postgreSQL
Previous:From: David FennellDate: 2012-03-14 17:47:38
Subject: Streaming Replication Hooks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group