3 Replies Latest reply on Jun 28, 2018 4:06 PM by Peter Fakan

    Tableau Impersonate SQL Server is SELECT Access Needed


      I have a Tableau workbook (10.5) driven by one SQL Server table. I want to impersonate through a tabserver account to allow AD\johndoe to connect:

      1. Add AD\johndoe as a Windows user to SQL Server
      2. Grant connect to AD\johndoe
      3. Grant impersonate on AD\johndoe to tabserver
      4. Publish workbook with Impersonate with Embedded Password option

      Do I need to grant select on the table driving the workbook to AD\johndoe? I thought I didn't, but my user couldn't connect without it.