Database Administration (MOSC)

MOSC Banner

Collecting data for audit.

edited Aug 20, 2012 7:35AM in Database Administration (MOSC) 6 commentsAnswered
DB: 11g Enterprise EditionOS: Windows Server 2008
Parameter AUDIT_TRAIL: DB (since 2010)

With the goal of gathering data for audit, I need to collect the following data:
1) In the last year, which users have created or changed tables?
2) When the user SYSTEM was used and operations performed?
3) When the user SYS was used and operations performed?

And information:
A) How can I trace the actions performed by a particular user within a period.
Finally, how can I ensure that the data of audit tables were not deleted or changed?

Thanks

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