2 Replies Latest reply on Sep 15, 2015 7:48 PM by amrendra mohanty

Can custom SQL be modified with out database credentials?

amrendra mohanty Jul 8, 2015 3:14 AM

We have a packaged tableau workbook accessing data from oracle database which is published to tableau server with database connection,embedded passwords and sql statments.

We have users with site administrator role,

1) can these users change/edit the sql statements in tableau server without oracle database credentials?

2) can these users change/edit the sql statements in downloaded packaged workbook without oracle database credentials?

Please share any supporting documents or blogs or knowledge base for this clarification.

Capture.PNG 27.6 KB

1. Re: Can custom SQL be modified with out database credentials?

diego.medrano Sep 10, 2015 2:31 PM (in response to amrendra mohanty)

Hey Amrendra,

Database credentials are stored in the connection and not in the actual workbook. If the workbook is downloaded, users will be prompted for the Oracle credentials when opening the workbook. If users try to web edit the workbook in Tableau Server, they will be prompted for credentials. Therefore, I can't envision a scenario where a user could edit the custom SQL without knowing the DB credentials.
Like Show 0 Likes(0)

Actions
2. Re: Can custom SQL be modified with out database credentials?

amrendra mohanty Sep 15, 2015 7:48 PM (in response to diego.medrano)

Thanks Diego!
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Can custom SQL be modified with out database credentials?

1. Re: Can custom SQL be modified with out database credentials?

2. Re: Can custom SQL be modified with out database credentials?

Actions

More Like This