I suspect this worked by accident in Opus 9. Trying it in the old version just now, it doesn't re-use the existing connection and instead creates a new one, prompting me for the password again, etc. which is a bit clunky.) But even if it only worked by accident, it was probably only broken by accident as well.
I've filed a bug report to see what Greg & Jon think.
This ability should be restored in the next update. (Testing in a pre-release version, it no longer asks me for my password like it did in Opus 9, too.)
Only program wide, but you'll only be asked when pasting an image or text from the clipboard, not when using ctrl-c / ctrl-v to copy files around, FWIW.
If you only want to be asked sometimes for image/text data you'd have to set up a different hotkey. (e.g. Ctrl-Shift-V maybe.)