Fine-grained Auditing DBMS_FGA
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?