Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: "nirav" <shivam71@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: using fine grain auditing to audit selects on ALL tables..possible??
Date: 12 Dec 2005 06:36:49 -0800
Organization: http://groups.google.com
Lines: 18
Message-ID: <1134398209.460985.280590@g43g2000cwa.googlegroups.com>
NNTP-Posting-Host: 203.197.254.126
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1134398215 16603 127.0.0.1 (12 Dec 2005 14:36:55 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 12 Dec 2005 14:36:55 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=203.197.254.126;
   posting-account=EIIp9Q0AAABx3TtORI4efSnWEZQGHNCc
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:257546

Hi,

We are on oracle 9i (9.2.0.6) on solaris 8. We have a schema to which
the application is connecting and we need to debug what all tables it
accesses..I know that for a given table , we can create a policy via
dbms_fga and do the fine grain auditing, but my question is can we do
that for ALL tables in the schema?


btw, I know that for all tables it is possible to do standard audit ,
but currently the audit is turned off , and to turn it on  , the
database restart is needed(to set up audit_trail etc) which I want to
avoid...

thanks,

N.