SP3 Adds Security Option for Cross-Database Ownership Change

SQL Server 2000 Service Pack 3 (SP3) provides an enhanced security-related option for configuring cross-database ownership chaining during setup: "Enable cross-database ownership chaining for all databases." The Microsoft article "INF: Cross-Database Ownership Chaining Behavior Changes in SQL Server 2000 Service Pack 3" explains the new option, which lets you control whether or not to permit cross-database ownership chaining. By default, this option is disabled, and Microsoft recommends that you use the default option because it makes your database server more secure.


Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.