---
schema_version: "1"
id: 344c07a887f4963bd7bfc419efb78a55e4f01db2ae3d67a7ff5ffbce798346aa
title: How Impersonation Works
collection: tableau
version: next
locale: en-us
portal_url: https://docs.salesforce.com/tableau/next/en-us/server-linux/impers_how.md
canonical_url: https://help.tableau.com/v0.0/server-linux/en-us/impers_how.htm
source_site: help.tableau.com
content_type: documentation
content_hash: b466910e01580a9d6730f4b2aa1506a620c76f3d978dd66fc601f23dfda5c4bf
description: Understand how SQL Server database user impersonation works in Tableau Server.
---
[Skip to main content](#main-content)

# How Impersonation Works

Here’s an illustration of how database user impersonation works:

![A diagram that illustrates how Tableau Server and SQL Server interact to impersonate workbook viewers.](/tableau/next/en-us/server-linux/en-us/Img/impersonate.png)

In the above illustration, Jane Smith (MyCo\\jsmith) is a West Coast sales representative and Henry Wilson (MyCo\\hwilson) covers the East. In the SQL Server database, the account permissions for Jane's account, MyCo\\jsmith, only give her access to West Coast data. Henry's account, MyCo\\hwilson, can only access data for the East Coast.

A view has been created that displays data for the entire country. It has a live connection to a SQL Server database. Both users sign in to Tableau Server and click the view. Tableau Server connects to SQL Server using a database account with IMPERSONATE permission for each user's database account. This account acts on behalf of each user's database account.

When the view displays, it is restricted by each user's individual database permissions: Jane sees only the West Coast sales data, Henry sees only the East Coast data.

**Note:**Tableau Bridge does not support SQL impersonation using Initial SQL.