Is there a specific parameter that can be used in a SQL server/azure connection string to specify that the connection should be readonly?
In other words, only SELECT queries should work but INSERT/UPDATE/DELETE and DDL statements should return an error.
I'm aware of the ApplicationIntent=ReadOnly parameter, but my understanding is that its purpose is to connect to read replicas. In my case, the target server might not have any read replica. In this case, would ApplicationIntent=ReadOnly be enough to make the conneciton read only even though it connects to the primary?