I have established a successful connection to an SQL Server. I have created two flows, one to trigger "When an item is modified (V2)" and another one to trigger "When an item is created (V2)". Whenever I make a valid create or update at the SQL Server side, the flows are not triggered. One thing to note here is that the credentials used to establish a connection with the SQL server is having only read only permission, that too on two table.
Note: The flows are attached to those two tables only.
Is it possible that the flows are not triggered because of the read only permissions??
I was under the impression that SQL server connection relies on polling to identify change and does more privileges or access permissions required to perform the same?