I recommend LOCTITE for locking threads on adapters. Here's a breakdown of their color/strengths: http://na.henkel-adhesives.com/industrial/Loctite-Threadlockers-by-Color-14023.htm
I use red for the stuff I know I'll never need to break apart and blue or purple for stuff I may need to break loose at some point.
^ My very first experience with Loctite was after reading a tip here, I believe from you, about using an eye bolt into the threaded hole on a SuperClamp as an attachment point for safety cables. I went to the hardware store with a SuperClamp in hand, and asked the guy if he could cut down some eye bolts for me, and why. I got a couple, as I often use two clamps for spaced omnis, and the guy said, "You should add some Loctite; it will prevent the bolt from loosening and make your safety system more secure." Sounded good to me. He applied some red and sold me the rest of the bottle. Needless to say, I now have a SuperClamp with a permanently attached eye bolt...
We use a lot of Loctite Red at work for securing stainless bolts in drilled/tapped holes in aluminum parts. I warn customers not to try and remove these bolts by brute force, as they will often end up shearing the bolt off before the thread-locking compound gives way. It is then near-impossible to successfully extract the remainder of the stainless bolt from the softer aluminum without destroying the part.
The key to successful disassembly of parts secured with Loctite Red is to heat the area (if even just the head of the bolt if heat would damage the finish of the threaded base material) with something like a propane torch prior to applying torque to remove the fastener. The heat breaks down the thread-locking compound allowing the bolt to be loosened with far less torque.
We use Red because these applications are subjected to repeated reciprocal motion which would otherwise loosen the bolt over time and there is no other good way to mechanically lock the bolts in place securely. Best to use the less aggressive formulations for assemblies which will need to be disassembled at some point, which should be entirely sufficient for most applications except those subjected to on-going repeated reciprocal motion or extreme vibration.