I have been asked a question which i am struggling to find information online. When you set up a linked server does the user referenced in a linked server automatically gets the db_ddladmin role, if not what role does it get?
Thanks in advance.
This topic was modified 1 month, 2 weeks ago by rogue1009.
Which user? Do you mean the user that you specify as the credential when you create the linked server? This is a credential on the remote database that you have already set up. This isn't a user that is added to the remote by the create linked server dialog
This notes that you can use the security context of the user querying the linked server or set up a set of credentials to connect. This is a way to set a security context for a user that runs your query on the remote system.
Or are you asking for something else? It's not clear what you mean by the user.