I’ve had my H&K 9mm USP Compact loaded with a magazine and one round chambered in my nightstand for 24+ years without ever having an issue. Even with 3 toddlers back in the day, I NEVER had any issues with unauthorized access.
Where should you keep it, under your pillow?
I usually have it with me every moment of the day. (That is: Yes.)