SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
BUG in triggers creation

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
BUG in triggers creation
Author Message
Nuno



Joined: 12 Feb 2003
Posts: 4

Post BUG in triggers creation Reply with quote

When you create a trigger to audit just some operations like INSERTS in a table DB_AUDIT builds the trigger correctly but it always inserts a row in data_audit_trail with audit_inserts, audit_deletes and audit_updates populated with 1 which is the default value. Afterwards if you try to change the trigger through the utility I noticed that it considers for all tables that all type of operations have been chosen to be audited.
Do you have any fix for this issue?
Have anybody noticed this problem before?

Nuno

Wed Feb 12, 2003 1:35 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: BUG in triggers creation Reply with quote

Which DB Audit version are you running?
On which database system?

: When you create a trigger to audit just some operations like INSERTS in a
: table DB_AUDIT builds the trigger correctly but it always inserts a row in
: data_audit_trail with audit_inserts, audit_deletes and audit_updates
: populated with 1 which is the default value. Afterwards if you try to
: change the trigger through the utility I noticed that it considers for all
: tables that all type of operations have been chosen to be audited.
: Do you have any fix for this issue?
: Have anybody noticed this problem before?

: Nuno

Wed Feb 12, 2003 1:39 pm View user's profile Send private message
Nuno



Joined: 12 Feb 2003
Posts: 4

Post Re: BUG in triggers creation Reply with quote

: Which DB Audit version are you running?
: On which database system?
I am running demo version 2.0.10 in Oracle 8.0.5.

Wed Feb 12, 2003 3:20 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: BUG in triggers creation Reply with quote

I am checking this...

: I am running demo version 2.0.10 in Oracle 8.0.5.

Wed Feb 12, 2003 4:27 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: BUG in triggers creation Reply with quote

Yes, that appears to be a bug. The audit objects are generated correctly but a matching record in the repository table is not updated correctly. As a result the GUI always shows all audit options selected including INSERT/DELETE and UPDATE operations regardless of what options were previousl y selected for the auditing.

This bug is considered as high priority and it will be fixed as soon as possible and included with version 2.0.11 which should be released either tomorrow or immediatelly after the weekened.



Thu Feb 13, 2003 1:53 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: BUG in triggers creation Reply with quote

The repository issue is now fixed. This fix is available in v2.0.11. Please upgrade.

Thu Feb 13, 2003 9:42 am View user's profile Send private message
Nuno



Joined: 12 Feb 2003
Posts: 4

Post Re: BUG in triggers creation Reply with quote

: The repository issue is now fixed. This fix is available in v2.0.11. Please
: upgrade.
From where can I download trial version from?

Tue Feb 18, 2003 9:23 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Re: BUG in triggers creation Reply with quote

click the download link available on the product home page http://www.softtreetech.com/dbaudit/index.htm

: From where can I download trial version from?

Tue Feb 18, 2003 10:38 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.