Who Watches The Watchers - S3-E4
Revealing mistake: About 38 minutes into the show, when Dr. Mary Warren dies and there's a close up of Picard & Nuria, you can see the her hand moving up and down as she breathes.
Yesterday's Enterprise - S3-E15
Revealing mistake: When Tasha and Castillo walk up to the bar in Ten Forward, Whoopi Goldberg can be seen standing outside the door waiting for her cue to walk in the room.
Revealing mistake: Just after Riker and Geordi are talking in the turbo lift, it cuts to a view from outside the ship and shows the USS Hood flying next to the USS Enterprise. As the ships draw nearer, the views of both ships overlap, and a black mat outline can be seen around the saucer section of the Hood as it passes by the Enterprise's starboard nacelle.
The Best of Both Worlds (1) - S3-E26
Revealing mistake: During the phaser battle on the Borg ship, a detonation wire is seen attached to the right foot of the drone that Beverly kills.
Answer: Yes. The doors to the holodecks can be locked when in use by anyone aboard the Enterprise so they couldn't be disturbed. However, high ranking officers like Captain Picard could override the doors as it's seen that overrides are in use even for the crews quarters. Even Barclay, when he's indulging in one of his fantasies could have the doors to the holodeck unlocked by an override code.