CBD oil

Has anyone been able to successful have CBD oil prescribed for their child?
My child is ASD and has severe aggression problems. He is constantly on the move, barely sleeps.
We have tried other medications which haven’t been at all effective. As it stands now, he is only young and is only going to get bigger and stronger. He is going to end up unintentionally hurting someone badly. He doesn’t have capacity to understand the extent of what he is doing.