OraFAQ Forum: Server Administration » Please Help me in Fine Grain Auditing (FGA)......How to enable it

Home » RDBMS Server » Server Administration » Please Help me in Fine Grain Auditing (FGA)......How to enable it

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Please Help me in Fine Grain Auditing (FGA)......How to enable it [message #173358]

Mon, 22 May 2006 01:50

rajvaida
Messages: 26
Registered: May 2006
Location: India

Junior Member

can anybody help in Fine Grain Auditing (FGA)

I am using Oracle 10g XE. I am getting following error...

SQL> BEGIN
2 DBMS_FGA.ADD_POLICY (
3 OBJECT_SCHEMA=>'RAJ',
4 OBJECT_NAME=>'DUP',
5 POLICY_NAME=>'DUP_ACCESS' );
6 END;
7 /
BEGIN
*
ERROR at line 1:
ORA-00439: feature not enabled: Fine-grained Auditing
ORA-06512: at "SYS.DBMS_FGA", line 17
ORA-06512: at line 2

Thanx & Regards

Raj S Vaida

Report message to a moderator

Re: Please Help me in Fine Grain Auditing (FGA)......How to enable it [message #173377 is a reply to message #173358]

Mon, 22 May 2006 03:37

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

It works with Oracle Enterprise Edition:

SQL> BEGIN
  2    DBMS_FGA.ADD_POLICY(
  3           OBJECT_SCHEMA => 'SCOTT',
  4           OBJECT_NAME   => 'EMP',
  5           POLICY_NAME   => 'DUP_ACCESS');
  6  END;
  7  /

PL/SQL procedure successfully completed.

So, one must assume that FGA is not supported with XE.

$ oerr ora 00439
00439, 00000, "feature not enabled: %s"
// *Cause:  The specified feature is not enabled.
// *Action: Do not attempt to use this feature.

Report message to a moderator

Previous Topic:	synonym returns no rows
Next Topic:	SYSTEM User droped

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:39:27 CDT 2024