Welsh Corgi
SSC Guru
Points: 116520
More actions
May 10, 2012 at 9:01 am
#256289
It was only yesterday that I granted a user permissions to SELECT on a Linked Server.
I had to make them a member of Public on Master and GRANT Execute to an Extended Procedure.
I tried to search for the command but I can't find it.
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 10, 2012 at 9:05 am
#1485764
I found it.
GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO Login;
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply