RE: database auditing

From: Chen, Sarah <Sarah_Chen_at_BUDCO.com>
Date: Mon, 18 Jul 2005 14:36:30 -0400
Message-ID: <810139D60775D71191B100306E058F21019147B7@budco_exch2.budco.com>

We would like to track which tables have been access through Oracle Forms base on the functionality of the application.

Sarah

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Chen, Sarah Sent: Monday, July 18, 2005 2:21 PM
To: 'ORACLE-L_at_freelists.org'
Subject: database auditing

Good afternoon

Database: 10.1.0.4
OS:Sun

Does anyone know any specific way of auditing the whole application schema in database? FGA sets up policy for each objects(table/view), but I have 997 tables own by this particular application schema. I definitely do NOT want to set up one policy for each of the table. Any idea of how to set up one policy for one schema? Or any other suggestions?

Thanks

	Best Regards,
	Sarah Chen
	Information Technologies
	Sr. Oracle Database / Application Server Administrator
	Budco - The Dialogue Company

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon Jul 18 2005 - 13:38:27 CDT