Who deleted the rows and tables

[former_member217468]

hi ,

Is it possible to find who deleted a bunch of rows or certain tables from HANA db .

Thank you

Jonu Joy

[vivekbhoj]

Hi Jonu,

You can set up an audit policy for it:

But be careful with ALTER TABLE policy as it will record all inserts, deletes and updates made to the table.

Regards,

Vivek

[former_member217468]

can this be pulled out from the log segments too .

[lbreddemann]

Alright, how do you do that on SAP HANA, hm? You mind showing us?

[former_member217468]

i dont know how to do that , thats why i am asking and i thought this forum is to ask any doubts on HANA

[lbreddemann]

Well your last statement didn't read like a question.

But the answer is: no. There is no option for non-core developers to read anything out of the redo log stream.

- Lars

[former_member217468]

Thank you