Audit, log, report, table, tables, list., KBA, GRC-SPC-RE, Reports and Dashboards, How To About this page This is a preview of a SAP Knowledge Base Article.
Symptom
Audit log report retrieves the data directly from SCU3 logs and helps to identify the changes done on GRC system. Customer wants to understand the tables that can be logged in order to retrieve the changes.
- 1) In the SAP HANA Studio expand the system on which you would like to enable auditing. 2) Expand the ‘Security’ folder. 3) Double click on the ‘Security option.’. 4) Click on the Auditing Status drop down menu; by default it will be ‘Disabled.’. 5) Select ‘Enabled.’. 6) Select your auditing type.
- To create an audit log for the user SAP., you must enable generic user selection and escape the asterisk. Number of Selection Filters. Number of filters to allow for the security audit log. One Audit File per Day.
- Audit Trail is an SAP Netweaver component that you can use to log all ERP applications. In addition to Audit Trail, there is the Electronic Records component in SAPAPPL, which also provides logging functions (however, only for applications in SAPAPPL).
Environment
SAP GRC Process Control 10.0
SAP GRC Process Control 10.1
SAP GRC Process Control 12.0
Product
Keywords
audit, log, report, table, tables, list. , KBA , GRC-SPC-RE , Reports and Dashboards , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
- SAP HANA Tutorial
- SAP HANA Introduction
- SAP HANA Modeling
- SAP HANA Reporting
- SAP HANA Security
- SAP HANA Data Replication
- SAP HANA Monitoring
- SAP HANA SQL
- SAP HANA Useful Resources
- Selected Reading
SAP HANA audit policy tells the actions to be audited and also the condition under which the action must be performed to be relevant for auditing. Audit Policy defines what activities have been performed in HANA system and who has performed those activities at what time.
SAP HANA database auditing feature allows monitoring action performed in HANA system. SAP HANA audit policy must be activated on HANA system to use it. When an action is performed, the policy triggers an audit event to write to audit trail. You can also delete audit entries in Audit trail.
In a distributed environment, where you have multiple database, Audit policy can be enabled on each individual system. For the system database, audit policy is defined in nameserver.ini file and for tenant database, it is defined in global.ini file.
Activating an Audit Policy
To define Audit policy in HANA system, you should have system privilege − Audit Admin.
Go to Security option in HANA system → Auditing
Sap Audit Tcode
Under Global Settings → set Auditing status as enabled.
You can also choose Audit trail targets. The following audit trail targets are possible −
Change Log Table In Sap
Syslog (default) − Logging system of Linux Operating System.
Database Table − Internal database table, user who has Audit admin or Audit operator system privilege he can only run select operation on this table.
CSV text − This type of audit trail is only used for test purpose in a non-production environment.
You can also create a new Audit policy in the Audit Policies area → choose Create New Policy. Enter Policy name and actions to be audited.
Sap Audit Log Table 2018/19
Save the new policy using the Deploy button. A new policy is enabled automatically, when an action condition is met, an audit entry is created in Audit trail table. You can disable a policy by changing status to disable or you can also delete the policy.