Grant User Permission to SELECT on a Linked Server

• 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/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  May 10, 2012 at 9:05 am

  #1485764

  I found it.

  GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO Login;

  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/