Hi,

What does this script do?

grant execute on xp_prop_oledb_provider to [User_ID]

I'm currently encountering this error and nto quite sure if this is the only to resolve this error: "Execute permission denied on object 'xp_prop_oledb_provider ', database 'mssqlsystemresource', schema 'sys'"

Is granting execute permission to this extended sp will just grant the user to show the catalogs under there linked server? I'm afraid i will grant them other permission other that what the user and application's linked server should be doing..

Thanks for your inputs! 🙂