Are privileges granted on database objects replicated to the secondary database?

• A. Yes
• B. Not replicated in all cases
• C. Only for certain objects
• D. No

Answer: (D)

In Snowflake replication, the data and object definitions are copied to the secondary, but the security/permissions on those objects are not automatically replicated. Privileges granted to roles on databases, schemas, tables, etc., live in the account’s access control metadata and aren’t carried over to the secondary during replication. So after the secondary is created or brought online, you must re-grant the necessary privileges in that account to restore the same access controls.

This is why the correct stance is that privileges are not replicated to the secondary. Granting on the secondary should be handled separately to reflect the appropriate role structure and security requirements there.