User access on Azure SQL DB secondary replicas

Question

Hi Team,

Next week we are planning to create an Azure SQL DB secondary replica at (US East) Primary at US West.

Is it necessary to manually sync logins and assign permissions at the Secondary replica from the primary or is it automatic?
I mean how to make sure that user logins and their permissions are same on both primary and secondary.

Answer 1

Logins that were created at the server level (master database) and then were used to create users at the database level, you will find the users are replicated, but the server login (at the master database) won't exist on the secondary region and will have to be manually recreated on the logical server at the secondary region.

However, contained database users are replicated and exist on the secondary replicas of user databases. For this and many reasons it is a good choice to create contained database users on Azure SQL.

Answer 2

@Vijay Kumar As @Alberto Morillo mentioned you could have different permissions. It is not automatically sync. You have to do it manually.

Regards,
Oury