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

Adding ddl audit trigger

From: El Co <lc4od(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Adding ddl audit trigger
Date: 2011-01-26 21:30:28
Message-ID: 702620.23587.qm@web111404.mail.gq1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
Trying to get some DDL auditing in a development environment by adding triggers 
to pg_proc, pg_class,pg_type,pg_trigger and getting the following error:
 
ERROR: permission denied: "pg_proc" is a system catalog
SQL state: 42501
 
Is there any way to achieve DDL auditing in Postgres and trace any 
new/dropped/changed object into a table? All I need is to at least be able and 
save a userid(current_user), timestamp, action, and the name of the object and 
this could be done easily by adding triggers to these pg catalogs.


      

Responses

pgsql-general by date

Next:From: Guillaume LelargeDate: 2011-01-26 21:54:34
Subject: Re: Adding ddl audit trigger
Previous:From: Lawrence CohanDate: 2011-01-26 21:29:22
Subject: Adding ddl audit trigger

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