:::: MENU ::::

Cross-Database Ownership Chaining Enabled (DB_CHAINING) in SQL Server

  • Nov 05 / 2008
  • 0
dbDigger, Security and Permissions, System Stored Procedures

Cross-Database Ownership Chaining Enabled (DB_CHAINING) in SQL Server

Cross-Database Ownership Chaining Enabled is a security feature that controls database access by external resources, such as objects from another database. When set to TRUE in SQL Server Management Studio or ON when using the ALTER DATABASE command, the database can be the source or target of a cross-database ownership chain. Setting the Cross-Database Ownership Chaining to FALSE prevents participation in cross-database ownership chaining.
This option is effective only when the instance wide cross db ownership chaining server option is set to 0.
When the cross db ownership chaining option is enabled via SQL Server Management Studio or set to 1 via the sp_configure stored procedure, this option is ignored and all databases in the server can participate in cross database ownership chaining.

Consult us to explore the Databases. Contact us