From the course: SQL Server: Security for Developers

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Demo: Linked servers

Demo: Linked servers - SQL Server Tutorial

From the course: SQL Server: Security for Developers

Start my 1-month free trial

Demo: Linked servers

“

- [Instructor] So this demo is about linked servers and linked server security. The first thing I wanna tell you about is that here we have two servers, and they're actually even joined to a domain, so technically, we have three. So I wouldn't bother trying to follow along with this demo at home, it's gonna be a little bit difficult to set up. But I'll walk you through it, and you'll see what I'm gonna do here. The first thing is you'll note that we have on the left, an Object Explorer here. We have LINKEDSERVER01, and LINKEDSERVER02. If I expand Databases on LINKEDSERVER01, you'll see I've created DemoServer1. That's the script here on the right. And here I have added a table called employees. I've put a few rows of data starting on line nine, so I've put the name of our employees, and their salaries. And then on line 15, this is kind of the key take away from this setup script, is I'm granting select on the table to demo\user1. User1, this is the only permission he has in this…

Contents