Oracle Database Fine Grained Auditing (FGA)

Oracle Database  Fine Grained Auditing (FGA)

1. addd the details which you want to audir.

like....i want if any one select salary column from sal table for id 10.

SYS@KULLU>>exec  dbms_fga.add_policy('SCOTT','SAL','RAJ_POL','ID=10','SALARY','SELECT');

PL/SQL procedure successfully completed.

SYS@KULLU>>

2. Check in FGA audit trail table for auidted record.

SYS@KULLU>>select db_user,object_schema,sql_text from dba_fga_audit_trail;

no rows selected

3.login with scott on other session and run the query.....select * from sal where id=10;

SYS@KULLU>>select db_user,object_schema,sql_text from dba_fga_audit_trail;

DB_USER                        OBJECT_SCHEMA
============================== ================= SQL_TEXT===============

SCOTT                          SCOTT                                                                            select * from sal


SYS@KULLU>>select db_user,object_schema,sql_text from dba_fga_audit_trail;

DB_USER                        OBJECT_SCHEMA
============================== ==============================SQL_TEXT================================================================================

SCOTT                          SCOTT select * from sal
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
in this a table is created on scott schema and on salry column policy has made for accsing the salry data whose id=10;