Database Security Products (MOSC)

MOSC Banner

Ask about FGA in 11gR1

edited Dec 4, 2011 10:08PM in Database Security Products (MOSC) 8 commentsAnswered
 Hi,
   My db server (11gR1 on Linux 64) was enabled FGA by a DBA (and now he's leave this position). In my db, some tables were audit by use the DBMS_FGA.ADD_POLICY. I can select from dba_fga_audit_trail table to view operations from all of users. But now, size of table is large (it contains multi records) and I want delete amount of records that base on the Timestamp field. I can delete them manual or create job scheduler to delete them.

  I want ask Oracle support some parameters to delete them automatically (so I need not write my job scheduler) ? I just read some documents about FGA and know Oracle supports store records as XML file format (with AUDIT_TRAIL = xml) but if I store audit records as xml file, how is it effect to my db persomance ?? 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center