3 Replies Latest reply on Jan 9, 2013 8:57 AM by Robert Royer

    Can you connect to a SQL database where you have limited access?

    Robert Royer

      We have a SQL Server 2008 R2 database that we use as our primary datasource for Tableau. It contains many different tables containing information from various departments and facilities. To this point, the connections have been pretty straight-forward. We recently setup a few new users who only had access to a couple of the tables. They cannot read/write any of the others. When they attempt to establish a connection from Tableau, no available databases show after connecting to the server. They do have access to the specified tables in SQL, we tested that. Is this a limitation in Tableau? Do the users need to have global access to the entire database used as a source? If so, does anyone have any workarounds?

       

      Thanks