hi, i need to know how can i put some tables in "audit"?? i used ttaad4160m000 but i didn't work... what can i do??

i have baan IV, and my OS is AIX 5.3 and i have oracle 9i

Hi there,

did you do a convert to runtime?

regards

Norbert

Here is the sequence that worked for me several times:
1. ttaad4110m000 : you need TWO database definitions, one without audit, one with audit.
2. ttaad4111m000 : tables you want to audit must be assigned to the database with audit
3. ttaad4116m000 : audit directory must be defined;
4. ttaad4162m000 : grant access to audit sequences to some users
Dont forget to convert to runtime DD in each session. Good luck!

Hi,
u can open file tabledef6.1 which is located in lib folder copy existing line to new line and change the table number. to enable audit, set the last column value to Y to indicated you want to audit the table.

Vishal

Hi,
u can open file tabledef6.1 which is located in lib folder copy existing line to new line and change the table number. to enable audit, set the last column value to Y to indicated you want to audit the table.
Don't do that, because all changes made by editor will be lost if you convert to runtime database definitions.

Hi,
u can open file tabledef6.1 which is located in lib folder copy existing line to new line and change the table number. to enable audit, set the last column value to Y to indicated you want to audit the table.

Vishal

Please note that this is dangerous, it doesn't update your dictionary. The next time you run the convert to runtime again you will lose the changes you made to this file.

Han