Let's assume that I have a Standard Normal variable $X\sim\mathcal N(0,1)$. I am looking for a variable $Y$ so that $Z=XY$ follows a normal distribution too (regardless of its mean and variance).
Which distribution should $Y$ follow in order to fulfil this requirement?