• No, cross-database ownership chaining is not enabled by default and you couldn't disable it. It used to be, until SQL Server 2000 SP3. After that, you must enable yourself. See Erland's warnings about enabling it. Make sure you don't expose more than you expected. It's a feature because there's a time and place for it. sounds like you've got such a case.

    K. Brian Kelley
    @kbriankelley