SAP HANA user audit log table
In SAP HANA, the user audit log table is called "SYS.AUDIT_LOG". This table stores information about user activities and system events, including login and logout activities, SQL statements executed, and privilege changes.
The table has several columns that capture relevant information, such as:
- SESSION_ID: Unique identifier for the user session
- USER_NAME: Name of the user performing the activity
- ACTION_NAME: Type of action performed (e.g., LOGIN, LOGOUT, SELECT, INSERT, etc.)
- OBJECT_NAME: Name of the database object involved in the action (e.g., table, view, procedure)
- STATEMENT: SQL statement executed by the user
- TIMESTAMP: Date and time when the activity occurred
- CLIENT_IP: IP address of the client machine from which the activity was performed
By querying the SYS.AUDIT_LOG table, administrators can track user activities, identify potential security breaches, and perform compliance audits
原文地址: https://www.cveoy.top/t/topic/iL8v 著作权归作者所有。请勿转载和采集!