Source SQL Server Database User Tasks
You must configure two database users for each SQL Instance being used as a source environment in the Delphix Engine:
- A Windows Authentication user (e.g. DOMAIN\delphix_src), corresponding to the Source Windows Login configured by your System Administrator (see Windows Users and Permissions on Database Servers)
- A SQL Login user (for example, delphix_db), which can be accessed using SQL Authentication over Java database connectivity (JDBC) to the database
The queries that these users perform do not modify data. Rather, they gather information such as database names, database sizes, recovery mode, and backup information. In some cases, the SQL Login may also be used to initiate copy-only database backups.
The following table summarizes the permissions that you must grant to these two users:
| Object | Privileges Required | Delphix DB User- delphix_db | Delphix OS User - delphix_src (Windows Login) | How to grant (using SQL Server Management Studio) | Purpose |
|---|---|---|---|---|---|
| Server | CONNECT SQL |  | | Granted by default when creating a login
| Access to the SQL Server instance |
Database: master | db_datareader | | |
| Access to information about attached databases |
Database: msdb | db_datareader | |
| Access to backup history | |
Each user database to be linked | PUBLIC | |
| Monitoring of database size | |
| Each user database to be linked | db_backupoperator | |
| Optional: Required for backups to be initiated by Delphix (using Delphix Managed Backups, or when opting to take a backup when performing a manual Snapshot) | |
| Additional privileges required for discovering AlwaysOn Availability Groups | |||||
| Server | VIEW ANY DEFINITION | | |
| Access to information on the configuration of Availability Groups |
| Server | VIEW SERVER STATE | | |
| Access to information on configured Availability Group listeners |
Target SQL Server Database User Tasks
You must configure one Windows Authentication database user (for example, DOMAIN\delphix_tgt) on each target instance, corresponding to the Target Windows Login configured by your System Administrator (see Windows Users and Permissions on Database Servers).
This database user needs the following privileges:
| Object | Privileges Required | Delphix OS User - delphix_tgt (Windows Login) | How to grant (using SQL Server Management Studio) | Purpose |
|---|---|---|---|---|
| Server | CONNECT SQL | | Granted by default when creating a login
| Access to the SQL Server instance |
| Server | sysadmin | |
| Create, drop, and modify databases and their metadata to support VDB provisioning |
Staging Target SQL Server Database User Tasks
One "Windows Authentication" database user (e.g. DOMAIN\delphix_tgt) must be configured on each Staging Instance, corresponding to the Staging Windows Login configured by your System Administrator (see Windows Users and Permissions on Database Servers).
This database user needs to be granted the following privileges:
| Object | Privileges Required | Delphix OS User (Windows Login) | How to grant (using SQL Server Management Studio) | Purpose |
|---|---|---|---|---|
| Server | CONNECT SQL | | Granted by default when creating a login
| Access to the SQL Server instance |
| Server | sysadmin | |
| Create, drop, and modify databases and their metadata to support Validated Sync operations |
Related Links
- Tasks for the SQL Server Database Administrator
- Tasks for the Windows Network Administrator
- Tasks for the Windows System Administrator
- Tasks for the Delphix Administrator
- Windows Users and Permissions on Database Servers