3467636 - Creating HANA audit policy fails with "sql syntax error: incorrect syntax near"

Following 2_s4hana_hana_audit_policy_recommended.sql to create HANA audit policy: _SAPS4_02 Schema Data Definition, it failed with one of the errors as below.

• scenario 1
  Could not execute 'CREATE AUDIT POLICY "_SAPS4_02 Schema Data Definition" AUDITING ALL ALTER TABLE ON SCHEMA SAPABAP1...'
  SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "ON": line 4 col 5 (at pos 94) 
  
  
• scenario 2
  "Could not execute 'CREATE AUDIT POLICY "_SAPS4_02 Schema Data Definition" AUDITING ALL CREATE TABLE, ALTER TABLE, DROP ...
  SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "SYNONYM": line 26 col 12 (at pos 538)
   
• scenario 3
  "Could not execute 'CREATE AUDIT POLICY "_SAPS4_02 Schema Data Definition" AUDITING ALL CREATE TABLE, ALTER TABLE, DROP ...
  SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "SCHEDULER": line 26 col 12 (at pos 538)

 "Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP HANA, platform edition 2.0

HANA, create audit, sql syntax error: incorrect syntax near, on schema, SYNONYM, SCHEDULER , KBA , HAN-DB-SEC , SAP HANA Security & User Management , Problem