Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

SQLGuy64 Ten Centuries Points: 1111 More actions · Answer 1

Hi,

We use linked servers, is database chaining a more secure technique than using linked servers?

chris geswein Old Hand Points: 375 More actions · Answer 2

SQLGuy64 (4/8/2015)
We use linked servers, is database chaining a more secure technique than using linked servers?

It serves a different purpose. Linked Servers cross server boundaries whereas this crosses database boundaries on the same server.

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 3

An excellent article about a topic I have never need to use. It is why I am keeping the default value to OFF.

But I think I will test shortly ...

ktd Newbie Points: 1 More actions · Answer 4

Newbie

Points: 1

September 9, 2020 at 2:54 pm

Your example fails on step 7.8 completely

John Davys Valued Member Points: 56 More actions · Answer 5

Valued Member

Points: 56

April 28, 2021 at 10:46 pm

Thanks for a very useful article!