jglunde
22nd August 2005, 18:38
Using BaaN IV c 4 SP15, there arised the following question: Is there a possibility to audit reading accesses of users, in means of if a user reads the bill of material or an item? My answer would be: No. There is only the possibility to audit change, insert or delete accesses. Am I right? Or has anybody another answer?
Thanks a lot.

Markus Schmitz
22nd August 2005, 18:42
You could enable tracing, but the performance impact would be so huge, that it would be rendered useless. So you are right it is not possible.

jglunde
22nd August 2005, 19:04
You could enable tracing, but the performance impact would be so huge, that it would be rendered useless. So you are right it is not possible.
But what about the setting "Application defined" in the field Security in Maintain Audit Information File, ttaad4160m000?
Thanks for reply

Markus Schmitz
23rd August 2005, 09:06
If I am not mistaken, the security setting just determines, what can be done with the recorded audit information and not, what information is recorded.

But to be hones, I never used this, so I might be wrong.

jorgem
23rd August 2005, 15:45
You can't get any things from BaaN. BaaN have only insert, update, and delete information

But you can do it from Oracle. There are Audit for insert, update, delete and select also.
But I'm not a DBA for help you how you can do it. Our DBA do it for us one time ago. Please ask to your DBA. And good lucky.

NPRao
23rd August 2005, 19:46
Is there a possibility to audit reading accesses of users, in means of if a user reads the bill of material or an item?
Did you try to explore - Table data/Table field data authorization ?

jorgem
23rd August 2005, 21:29
"Table data/Table field data authorization " is only for authorization to access to any body to read or modify any register.
But JGLUNDE want "audit reading accesses of users, in means of if a user reads the bill of material or an item".
JGLUNDE: you must look for informatio about oracle audit for "select".