Reply To: SQL AlwaysOn Availability Group – Readable Secondary


Thank you for your reply. Can you please advise if there is a document that outlines exactly what SQL privileges are required as opposed to a global sysadmin role? Our intent is to grant read-access to a single database as opposed to granting access to the HVR user the ability to control the entire SQL installation, including modifying the Availability Group replica to force a failover and become primary.

Thank you

© 2020 HVR

Test drive Contact us