search

SAP-samples / s4hana-hana-audit-policies

Templates for SAP HANA audit policies of SAP S/4HANA systems.
https://blogs.sap.com/2021/06/08/security-by-default-hana-audit-policies-for-s-4hana/
Apache License 2.0
15 stars 5 forks source link

Syntax error on _SAPS4_02 Schema Data Definition #18

Closed i029243 closed 11 months ago

i029243 commented 11 months ago

Hi there,

I was trying to create the Audit policy based on _SAPS4_02 Schema Data Definition for a S/4HANA system with HANA 2.0 Rev 64

Replaced <SAPABAP1> with SAPHANADB as schema.

I get syntax error , SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "ON": line 32 col 3 (at pos 701)

When I tried to recreate the audit policy via HANA Cockpit Auditing functionality , it seems that ON SCHEMA <SAPABAP1> does not appear to be a valid option.

Thanks L2R

saint-j commented 11 months ago

Hello L2R,

this syntax error indicates that your SAP HANA Version does not support this policy definition. The minimum version should be SAP HANA 2.0 SPS07.

best regards jane

i029243 commented 11 months ago

Thank you for the update. I did not notice any comments about HANA 2.0 SP07 as prerequisites for that policy.

saint-j commented 11 months ago

Hi L2R,

please review the comments in 2_s4hana_hana_audit_policy_recommended.sql

directly above the definition of "_SAPS4_02 Schema Data Definition" - line 50.

bst regards jane