Help Center > > 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?

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

Updated at: Apr 20, 2020 GMT+08:00
  • 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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel