• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 551
  • Last Modified:

using Oracle 10g to setup the FGA audit option

Dear all,

I read this:


To check how to turn on the FGA audit feature of Oracle.

and I just know this:

1) Check if FGA option has been turn on:

select * from v$option
 where parameter like 'Fine-grained%';

Open in new window

and the result is :

Fine-grained access control                                     
Fine-grained Auditing                                           

2 rows selected.

Open in new window

this means it has been turned on?

but when I do this :

select * from SYS.FGA_LOG$;

Open in new window

the result return nothing, so this mean the FGA policy based audit has no policy turned on and that's why record in FGA_LOG$ table?

select * from DBA_FGA_AUDIT_TRAIL;

Open in new window

also said no row returned.
  • 2
1 Solution
What is your question????

You're right, the only thing you still have to do is defining a FGA policy.

Use package function DBMS_FGA_Add_Policy(..)

Chapter Creating An FGA Policy on below link shows you how to do it...

Fine Grained Auditing (FGA)
marrowyungSenior Technical architecture (Data)Author Commented:
"What is your question????"

this means it has been turned on? I am not sure if the FGA in our Oracle 10g has been enabled .

but both query below return nothing:

1) select * from SYS.FGA_LOG$;
2) select * from DBA_FGA_AUDIT_TRAIL;
marrowyungSenior Technical architecture (Data)Author Commented:
it will be perfect if all question can be answer.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now