RE: database auditing

Are you concerned about auditing? Recording each user access to objects? Or, about restricting access to those objects in the first place to authorized users? It sounds like something that can be managed by roles.

Don Freeman
Database Administrator 1
Bureau of Information Technology
Pennsylvania Department of Health
717-783-8095 Ext 337

-----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:35:21 CDT