Best practices

SQL Server instance with ‘cross db ownership chaining’ flag enabled

Description

Use the cross db ownership for chaining option to configure cross-database ownership chaining for an instance of Microsoft SQL Server. This server option allows you to control cross-database ownership chaining at the database level or to allow cross-database ownership chaining for all databases. Enabling cross db ownership is not recommended unless all of the databases hosted by the instance of SQL Server must participate in cross- database ownership chaining and you are aware of the security implications of this setting.
  • Recommended Mitigation

    Add the following database flag: 'cross db ownership chaining=off'.