how to see which user has assigned a content_profile content type?
According to the code of the content profile module (I didn't test this) you can use views relations between profile nodes (ordinary cck node types) and users.

I'm not sure whether you have to base your view on the cck node type for the profile or users. But with one of these you should get an option to add the other side as a relation and then use fields of the user and the profile in the same view.