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
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
Database Permission FAQs
- Why Does the Root User Not Have the Super Permissions?
- What Are the Differences Between RDS ManageAccess and DAS Permissions?
- RDS for MySQL Built-in Accounts
- Does RDS for MySQL Support Multiple Accounts?
- Can Multiple Users Log In to DAS at the Same Time? Will the Accounts Be Locked If I Enter Wrong Passwords Several Times in a Row?
- Why Did I Fail to Create an Object on the postgres Database as a Common User?
- What Should I Do If a Role Failed to Be Deleted from an RDS for PostgreSQL Instance?
- Why Did My RDS for PostgreSQL Migration Fail?
- How Do I Grant the REPLICATION Permission to an RDS for PostgreSQL Database User?
- Why Is An Error Reported When I Attempt to Change a Table Owner of the RDS for PostgreSQL Database?
- How Are the Login Name Permissions of RDS for SQL Server 2017 Enterprise Edition Primary/Standby DB Instances Synchronized to Its Read Replicas?
- After a Primary Instance Account Is Deleted and Recreated on RDS for SQL Server, Will the Permissions Be Automatically Synchronized?
- How Do I View Authorized Databases After a Local Client Is Connected to a DB Instance?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore