SELECT PNAME, PCOL, FROM SYS.FGA$;
Gives the policy name and affected columns.
SELECT DBUID, CLIENTID, POLICYNAME FROM SYS.FGA_LOG$;
Gives audit trail of user, client id and audited policy. Can also get query details and object schema and name
Query against the regular audit log can be done against DBA_AUDIT_TRAIL and SYS.AUD$
Query against the regular audit log can be done against DBA_AUDIT_TRAIL and SYS.AUD$
No comments:
Post a Comment