Sweet Dreams

The protagonist moves to the city in hopes of getting into college. Fortunately for him, he will be living with two beautiful women. Fate can be capricious, the protagonist fails in his attempt to get the college scholarship he so desperately needs, but at the same time he discovers that he has a special power. The power to enter into people’s dreams so he can discover their secrets and modify their behavior.
What is the reason for this mysterious power, are there other people with similar powers, and is it the beginning of a much bigger adventure?