---
schema_version: "1"
id: d627f7570161295fc546334e599adde0b707660ab6432dd2793a72f69248de02
title: SQL Server Impersonation
collection: tableau
version: next
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/next/en-gb/server-linux/impers.md
canonical_url: https://help.tableau.com/v0.0/server-linux/en-gb/impers.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 38c82c0afc06f76097e7b16bcbb6623aa153dde4ea0914bafec249fcce1d9b20
description: Understand SQL Server impersonation, letting Tableau query on behalf of database users.
---
[Skip to main content](#main-content)

# SQL Server Impersonation

Impersonation in the context of Tableau Server means allowing one user account to act on behalf of another user account. You can configure Tableau and Microsoft SQL Server to perform database user impersonation, so that the SQL Server database account used by Tableau Server queries on behalf of SQL Server database users, who are also Tableau users.

The main benefit of this feature is it allows administrators to implement and control their data security policy in one place: their databases. When Tableau users access a view with a live connection to a SQL Server database, the view only displays what the users' database permissions authorise them to see. An additional benefit is that the users don't have to respond to a database sign-in prompt when they open the view. Also, workbook publishers don't have to rely on user-specific filters to restrict what's seen in views.

## Other articles in this section