x

cross db ownership chaining,need help

Im going through configuration settings at server level in SQL-2K5.Can anybody provide me best explanation about the property cross db ownership chaining.I already gone thorouh msdn but its giving me confusion.

what are the limitations?

what about the security risk?

when should we enable this property?

more ▼

asked Mar 25, 2010 at 12:02 PM in Default

venkatreddy gravatar image

venkatreddy
562 28 29 32

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Rob Farley has wrote a good article on this.. Pro's and Cons...

http://sqlblogcasts.com/blogs/rob_farley/pages/1140.aspx

more ▼

answered Mar 25, 2010 at 01:01 PM

sp_lock gravatar image

sp_lock
9.1k 24 27 31

+1 (ha!) - Oh wow, someone's found something I did on sqlblogcasts. That takes me back... (and saves me writing a proper answer here). Funny... I jump online in the Australian morning, and see a bunch of questions, but almost all are answered. So I vote for questions and answers, and then there's almost no activity here for ages.
Mar 25, 2010 at 08:19 PM Rob Farley
@Rob - to be honest - it hasn't felt like there's been much activity for a while - the whole net seems a bit 'sleepy' this week
Mar 25, 2010 at 08:29 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x21
x10

asked: Mar 25, 2010 at 12:02 PM

Seen: 1421 times

Last Updated: Mar 25, 2010 at 12:02 PM