Symptom

• You have executed the SQL commands to grant the privileges on specific user in the Primary DB but you are unsure if the same command needed to be executed in the secondary DB or if it would be automatically replicated by HANA System Replication.

  Or

• You wanted to know if grant privileges command in the primary site requires to put the HA cluster for maintenance mode and run the command in the secondary site manually.

Environment

• SAP HANA, platform edition 1.0
• SAP HANA, platform edition 2.0

Reproducing the Issue

You executed the following SQL command in the Primary Database :

GRANT SELECT to <DBuser>;

CREATE SCHEMA <SchemaName>;

GRANT SELECT on schema <SchemaName> to <DBuser>;

Cause

Need to understand the functioning of the SAP HANA System Replication.

Resolution

• The SQL command executed in the Primary DB would be automatically replicated in the secondary DB
• There is no need to stop the secondary system for maintenance.

Please check the below guide for more information:

https://help.sap.com/docs/SAP_HANA_PLATFORM/4e9b18c116aa42fc84c7dbfd02111aba/fb06367a182945eb9048f2b0fb788325.html#how-does-system-replication-work%3F