If access is removed from public role for a particular xp_.. (which is in public role), will a user with sysadmin role have access to that particular xp_..
sysadmin role members map into every database as dbo, including master. The dbo user never has permissions checked. Therefore, a member of the sysadmin role has access to all objects.
K. Brian Kelley @kbriankelley
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply