Help Center/ Relational Database Service/ FAQs/ Database Permission/ How Are the Login Name Permissions of RDS for SQL Server 2017 Enterprise Edition Primary/Standby DB Instances Synchronized to Its Read Replicas?
Updated on 2022-05-07 GMT+08:00
View PDF
Share

How Are 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 once per minute. Wait for about a minute until the synchronization is complete, and 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 once a 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 read replicas, the account password is synchronized to read replicas from the primary instance. Changing the Login Name permissions on read replicas will not have any effect.
Parent topic: Database Permission