Home » RDBMS Server » Security » FGA - AUDIT FILES (ORACLE 10.2.0)
FGA - AUDIT FILES [message #415069] Fri, 24 July 2009 10:44 Go to next message
dattakumar
Messages: 9
Registered: July 2008
Location: NEW JERSEY, USA
Junior Member
Dear Members,

I have invoked dbms_fga policy. In the View DBA_COMMON_AUDIT_TRAIL the rows are growing like anything. My question here is that, can we delete/truncate records from this table or not, like we do with AUD$.

Thanks in advance

Regards
Kumar

Report message to a moderator

Re: FGA - AUDIT FILES [message #415105 is a reply to message #415069] Fri, 24 July 2009 16:21 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Yes, just delete the records from FGA_LOG$ as you would for AUD$.

Report message to a moderator

Previous Topic: Lock user / ACCOUNT_STATUS in DBA_USERS (merged)
Next Topic: Keeping OS_AUTHENTICATION_PREFIX a null, Is this a security risk ??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 26 12:10:33 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.