e.g. a User John is registered from and is a member of "SITE A" in a multisite network, where his assigned role is "Charter Member". So, what I want is that when JOHN visits "SITE B" he has the privileges (i.e. I can get his role) as he has in "SITE A". But also I don't want to make JOHN member of "SITE B"
By default WordPress stores user capabilities/role in user_meta table but with site prefix like wp_3. Meaning that user role is site-specific.
please check the plugin "WP Multisite User Sync" in wordpress codex