It can be difficult to judge opinions in text and maybe I have not made it particularly clear anyway so I'll try and make it so.
Essentially, I do not think the SNP should be allowed to have a second referendum. A first one was fair enough, the Scottish people voted to stay in the UK and that choice should be respected. I personally don't care whether Scotland leave or stay overall, as long as a split means a full split, no financial help from the UK or "damages" to be paid, however if those in power have a referendum to decide something and do not get what they want, it sets a bad precedence for democracy in general. The same could be said for Bexit.