Database Administration (MOSC)

MOSC Banner

Fine-grained Auditing DBMS_FGA

edited Jan 27, 2014 2:41AM in Database Administration (MOSC) 5 commentsAnswered
Oracle 11.2 on Windows 2008 Server R2

Implemented some fine-grained auditing policies (very nice loop to capture all tables), but ran into problems deleting policies (partly because I used the DBA_FGA_AUDIT_TRAIL view to populate the DBMS_FGA.DROP_POLICY(...); statement.  Anyway, now I have lingering policies and no idea where Oracle is finding them.

I have no records in:  FGA$, FGACOL$, FGA_LOG$.  Nothing in the view, of course (DBA_FGA_AUDIT_TRAIL).  However, when I try to add certain policies, I get the error:

Question for the sports fans is this:  How do I locate the lingering policies?

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