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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Chen, Sarah Sent: Monday, July 18, 2005 2:21 PM To: 'ORACLE-L@xxxxxxxxxxxxx' 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l