Help Center> Relational Database Service> FAQs> Database Permission> How Do the Login Name Permissions of RDS for SQL Server 2017 Enterprise Edition Primary/Standby DB Instances Synchronized to Its Read Replicas?
View PDF

How Do the Login Name Permissions of RDS for SQL Server 2017 Enterprise Edition Primary/Standby DB Instances Synchronized to Its Read Replicas?

  • The Login Name permissions created by the primary DB instance are automatically synchronized to read replicas every minute. Wait for about one minute until the synchronization is complete, you can use the Login Name permission or changing password permission on read replicas.
  • You can add, delete, or modify the Login Name on read replicas because the Login Name permissions are automatically synchronized to read replicas every minute. The additional Login Names and permissions on the read replicas are not deleted due to the time difference. You can delete them from read replicas manually.
  • If a database account exists on both the primary DB instance and replicas, the account password is synchronized to read replicas from the primary instance. Changing the Login Name permissions on read replicas will not take effect.
Parent topic: Database Permission