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

• Don Kiely

  SSC Eights!

  Points: 959

  More actions

  April 8, 2015 at 12:00 am

  #316229

  Comments posted to this topic are about the item Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining

• SQLGuy64

  Ten Centuries

  Points: 1111

  More actions

  April 8, 2015 at 8:42 am

  #1789558

  Hi,

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

• chris geswein

  Old Hand

  Points: 375

  More actions

  April 8, 2015 at 9:49 am

  #1789594

  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

  April 12, 2015 at 4:49 pm

  #1790405

  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

  September 9, 2020 at 2:54 pm

  #3787347

  Your example fails on step 7.8 completely

• John Davys

  Valued Member

  Points: 56

  More actions

  April 28, 2021 at 10:46 pm

  #3877121

  Thanks for a very useful article!