Implementing hook_node_access and handling exceptions first to allow view for a specific users only depend on user profile field value.