Post reply

Public role has execute access on sp_addlinkedserver

  • April 21, 2014 at 8:35 am

    #292639

    Public role has execute access on sp_addlinkedserver in master db..(This is on SQL 2005 servers std/enterprise edition)..

    Is this default behaviour on SQL 2005..I donot see this issue on 2008R2.

    If so, Can you provide me any BOL link for this access

  • April 21, 2014 at 9:29 am

    #1707486

    I don't think this is the case. Public should have very few rights, and I'd be surprised at this. Public has few rights, and I wouldn't expect this to be the case. This should require ALTER ANY LINKED SERVER permission in 2005.

    http://msdn.microsoft.com/en-us/library/ms190479%28v=sql.90%29.aspx

    If I check my 2005 instance, I get permission denied for a new login with just public

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply