How to disable the Database flag cross db ownership chaining for Cloud SQL on the SQL Server instance in Google Cloud

Riyaz Walikar
Feature image


The cross db ownership for chaining option is used 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 essentially this is a security feature of SQL Server that allows users of databases access to other databases besides the one they are currently using.

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.

Steps to disable the “cross db ownership chaining” flag using Google Cloud UI

  1. Login to GCP and navigate to the Cloud SQL Instances page in the Google Cloud Console by visiting https://console.cloud.google.com/sql/instances

  2. Select the SQL Server for which you want to configure the database flag

    SQL Server

  3. Click on Edit button

    Edit SQL Server

  4. Scroll down to the Flags and parameters section

    Flags and parameters section

  5. To set a flag that has not been set on the instance before, click Add Flag, choose the flag cross db ownership chaining from the drop-down menu, and set its value to off

    remove cross db ownership chaining

  6. Click on Save button

    Save settings

  7. Confirm the changes under Database flags and parameters under Configuration section on the Overview page

    overview flags Page

← Back to Academy