Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we use FGA (Fine grained audit) in oracle standard edition ?

Oracle_24Aug 9 2011 — edited Aug 9 2011

Hi All

I am looking for your help.

I have set audit_trail parameter to db and when i have tried to add policy using BEGIN
DBMS_FGA.add_policy ... it shows ORA-00439: feature not enabled: Fine-grained Auditing

SQL> select from v$version ;*

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

SQL> select from v$option where PARAMETER in ('Fine-grained access control','Fine-grained Auditing') ;*

PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Fine-grained access control FALSE
Fine-grained Auditing FALSE

Thanks In advance :)

Edited by: Oracle_2410 on Aug 9, 2011 3:00 AM

Edited by: Oracle_2410 on Aug 9, 2011 3:10 AM

Edited by: Oracle_2410 on Aug 9, 2011 3:13 AM

This post has been answered by mseberg on Aug 9 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 6 2011

Added on Aug 9 2011

#general-database-discussions

10 comments

1,474 views