2 Replies Latest reply on Mar 26, 2018 10:35 PM by Peter Fakan

    Passing DB Username, Password

    peevee Reddy

      Hi All,

       

      I've a question in Tableau Desktop while connecting to Oracle DB. In case if a Business user would like to login in to Tableau Desktop with Service UserID, Password (DB Schema username, Password), is there any way that we can pass Username, Password automatically instead of Typing Username, Password as there is potential risk involved in knowing the schema password. The idea is instead of using the specific user ID, we would like to give a common ID to use

       

      Any ideas, please share. Thanks in advance for the help

       

      Thanks,

      PV

        • 1. Re: Passing DB Username, Password
          patrick.byrne.0

          Hello Peevee,

           

          If you have Tableau Server you can publish the data source as a live connection to Tableau Server and allow the users to connect to the published data source but prevent them from seeing the credentials.

           

          More information can be found in the Online Help guide: Data Security

           

          Hope this helps!

           

          Cheers,

          Byrne, Patrick

          • 2. Re: Passing DB Username, Password
            Peter Fakan

            Hi PV,

             

            We found that TS connects to databases using its network account and not a run as user account (that's just the way we setup our server), so using your logic you could give your tableau server network account permissions to access your database, although your security team will be screaming at you as this is really-really bad practice.

             

            Depends on how secure you need your database to be

             

            HTH

             

            Peter