Oracle, there is a table in the test, there are two records, a and b, in seven days ago someone one record a deleted, excuse me, how can to delete a record at the time the operator is which account? No rest

CodePudding user response:

If there is a file, so logminer, if not, the basic no way out, although I think find the user actually also is not the result you want, you want which may be specific to the client, which "people" do delete this sort of thing,

CodePudding user response:

could you please tell me, how can to delete a record at the time the operator is which account?

Refers to the application of the operator, the operator? Do not check this, business users, the users of the database, are all the same,

CodePudding user response:

Need to open the audit function

CodePudding user response:

reference CKC reply: 3/f

need to unlock the function of auditing

Data you can find it on the audit, very affect database performance, now need to be careful,

CodePudding user response:

Now=& gt; but

CodePudding user response:

reference 1st floor minsic78 response:

if there is a file, then the logminer, if not, the basic no way out, although I think find the user actually also is not the result you want, you want which may be specific to the client, which "people" do delete this,

Now is there is no recorded in the log file, all want from this method to check the specific day someone delete records,

CodePudding user response:

reference 4 floor qq646748739 response:

Quote: reference CKC reply: 3/f

Need to unlock the function of auditing

Data you can find it on the audit, very affect database performance, now need to be careful,

Thank you, the truth, don't know how to open the audit function,

CodePudding user response:

refer to the second floor wmxcn2000 response:

could you please tell me, how can to delete a record at the time the operator is which account?

Refers to the application of the operator, the operator? Do not check this, business users, the users of the database, are all the same,

Well, if not query the delete operator, only need to query the day is to delete the action, this can find it (in addition to the log, because of the log is cleared,)

CodePudding user response:

refer to 6th floor sucong response:

Quote: refer to 1st floor minsic78 response:

If there is a file, so logminer, if not, the basic no way out, although I think find the user actually also is not the result you want, you want which may be specific to the client, which "people" do delete this,

Now is there is no recorded in the log file, all want from this method to check the specific day someone delete records,

Log, basic can't accurate location, you can try to check who runs AWR base table, see if I can get to,
Also: audit, including the trigger such as technology, is the need to implement works after setting out,

CodePudding user response:

Open audit of performance influence is very big still,