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: (view raw, whole thread or download thread mbox)
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.



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-2017 The PostgreSQL Global Development Group