Azure SQL Managed Instances offer access to read replicas from the availability group (in specific tiers at least).
I am writing a test script for our application to connect to read/write and read only connections to prove everything is functioning as it should.
I know we can use the databasepropertyex SP to identify the current database access level, which will be enough.
However, the application user is obviously limited in permissions - so I want to grant the lowest possible permissions to the application user that still allows that user to identify the connectivity type.
I am really struggling to identify what permissions I need to grant to the app user that will allow them to see the output of this command - currently it returns 'NULL' regardless of rights I have granted.
I have obviously missed something somewhere!