A police investigation was launched after a hospital patient allegedly stole a key to a locked drugs cabinet