on 12-16-2014 1:52 PM
Hi,
In My Sap Hana tables some body is deleting Data.
Please help me How Can i Track them .
I mean which Session has deleted data in the table using Sap hana Sql.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You better develop a database trigger 'BEFORE/AFTER DELETE' on your suspected table and log the username and session information. Its better to assign authorizations properly to avoid such kind of issues
Sree
Instead of manually building triggers, using the built-in AUDIT functionality would be a good idea.
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.