DATABASE ADMIN GUIDE

SAP HANA Database Auditing

Part 1 of 2: Audit User Account Modifications

SAP HANA provides a great approach to audit database modifications. setting up and auditing the HANA database is simple and practical. Behind audit privileges, there are two system privileges we need to be aware of.

Let’s get started with the basics.

Photo by Kajetan Sumila on Unsplash

1. AUDIT ADMIN: for creating, modifying, and removing audit policies. As if you were a superuser with access to audit logs and modifications.
2. AUDIT OPERATOR: This user is responsible for reading audit logs. This access can be granted to any user because there is no risk of anything being deleted or changed.

Auditing is initially deactivated by default. To guarantee that the activities are logged to the audit log database, you must activate it. I’ll show you how to create an audit policy that can be used to track user creation, deletion, and modifications in this example.

Let’s find out the steps.

I’d love to hear whether this topic impacted your life, if there’s any area for improvement, or anything else!