I also needed to know what "xp_prop_oledb_provider" is all about? Can anyone help?

Are we granting another access to the user when we grant them additional execute permission in this procedure? :unsure: