Обсуждение: Auditing usage

Поиск

Список

Период

Сортировка

Auditing usage

От

"Little, Douglas"

Дата:

12 мая 2010 г., 18:36:42

Hi,

Is there anything in the system that would aid tracking who/how often an object (table/column/function/view) is accessed?

In Teradata we have an accesslog table that record attempted access to an object and if it’s granted or denied. Very important to our sox’s folks.

Thanks

Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide

500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

Вложения

image001.jpg

Re: Auditing usage

От

Richard Broersma

Дата:

12 мая 2010 г., 18:48:53

On Wed, May 12, 2010 at 2:36 PM, Little, Douglas <DOUGLAS.LITTLE@orbitz.com> wrote:

Is there anything in the system that would aid tracking who/how often an object (table/column/function/view) is accessed? In Teradata we have an accesslog table that record attempted access to an object and if it’s granted or denied. Very important to

This is the closed thing I've seen outside of scanning the postgresql logs.

http://www.depesz.com/index.php/2007/09/21/what-fields-are-usually-changed-when-updateing/

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Auditing usage

Auditing usage

Вложения

Re: Auditing usage