Skip to main content Skip to complementary content

Required permissions

The user specified in the endpoint settings must have the following privileges on the source database:

Adding users

Create users using Google Cloud Console only (Users > Add User Account). Users created any other way will not work as expected.

Running with the db_owner role

If the user is a member of the db_owner database role, the following permissions must be granted:

  • On the master database:

    • grant VIEW ANY DEFINITION
    • grant VIEW SERVER STATE
  • On the MSDB database:

    • grant SELECT ON SYSJOBACTIVITY

    • grant SELECT ON SYSJOBS

Running without the db_owner role

If the user is not a member of the db_owner database role, the following permissions must be granted:

On the master database:

  • grant VIEW DATABASE STATE

On the source database:

  • grant VIEW DATABASE STATE
  • grant SELECT

On the MSDB database:

  • grant SELECT ON DBO.CDC_JOBS
  • grant SELECT ON DBO.SYSJOBACTIVITY
  • grant SELECT ON DBO.SYSJOBS
Information noteThere are several limitations that apply when running without the db_owner role. For more information, see Limitations and considerations.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!