[Ronbo6]

The usual way to do this is once you have it where you want it, hit it with a pin punch at the joint between the dovetail and the base.

The times when I have gotten a bit 'wimpy' on the position I wanted it, I used blue Loctite. Doesn't mar anything up, and can be 'overpowered' if you need to move the sight.