I do not have much experience with auditing and need to audit the access to a table, whenever these access are done from any machine but the one that is allowed to do so. My problem is that access to the machine hosting this crucial table CAN be accessed via lots of machines, but for this particular table, I need to know when an access has been made to it, except for those access coming from the server that has legitimate access to it. Hope I am clear!
I have looked at the syntax of the AUDIT command, but doubt that I can use this. I would need to put a rule that would look somewhat like this:
audit all on my_table by "any connection not coming from machine XYZ";
I know I could do that with a trigger. I just want to make shure I am not overlooking something with the AUDIT command.
I have looked at the syntax of the AUDIT command, but doubt that I can use this. I would need to put a rule that would look somewhat like this:
audit all on my_table by "any connection not coming from machine XYZ";
I know I could do that with a trigger. I just want to make shure I am not overlooking something with the AUDIT command.
