Database Security Products (MOSC)

MOSC Banner

Fine Grain Auditing against schema in 11gR2

edited Apr 29, 2016 5:22PM in Database Security Products (MOSC) 1 commentAnswered ✓

Hello Community,

I have an 11.2.0.4 database with an old schema that I want to confirm is no longer being accessed.  I plan to move the tables to a new name and later drop the schema if I can confirm it is not needed any longer.  I would like to use Fine Grain Auditing to do this and I found an MOS document https://support.oracle.com/epmos/faces/DocumentDisplay?id=469007.1 that has a very good approach to capturing any activity against all tables in a schema and I tested out in 11.2.0.4.  I was just wondering if this method is still acceptable for this database version or if something better has come along.  The document only covers up to version 11.1.0.7.  I couldn't locate a newer approach in MOS or the 11.2 documentation.

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