-
1. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Jeff StraussMar 5, 2015 7:03 AM (in response to Anushka Chandrababu)
Let me know if you get an answer, we rarely login as tblwgadmin, but on occasion it is helpful.
-
2. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Toby ErksonNov 16, 2015 4:29 PM (in response to Anushka Chandrababu)
Have you tried this?
-
3. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Anushka Chandrababu Mar 6, 2015 12:08 AM (in response to Toby Erkson)Hi Toby,
Thank you for replying. Yes I did try this and that is when it asked for the password for tblwgadmin user in Tableau 9. In Tableau 8.3, by default there is no password set and the commands are executed.
Thank You
Anushka
-
4. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Toby ErksonMar 9, 2015 8:00 AM (in response to Anushka Chandrababu)
Darn, okay.
I guess Tableau is locking some of its doors to our "creativity".
-
5. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Matt ColesMar 6, 2015 8:43 AM (in response to Anushka Chandrababu)
On your Tableau Server host, open the file [ServerInstallRoot]\Tableau\Tableau Server\data\tabsvc\config\workgroup.yml
Search for the value: pgsql.adminpassword
This should work as the password to the tblwgadmin account. This is set randomly at install time--much better than "no password"!
-
6. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Vien HuaMar 8, 2015 4:51 PM (in response to Matt Coles)
Can you help me understand what the requirement or use-case is for having a super user role for the "tableau" user?
As of Tableau Server 8.2.5, the "readonly" user has read-only access to all of the tables. This should be sufficient to do any type of reporting on the database. We specifically do not let (or want) users to be able to modify the database as they wish. As you can imagine this could cause so many issues. Customers who have modified the database in the past faced issues when attempting to upgrade or taking backups and restoring.
Just be sure to take a backup before making any changes to the Postgres
-
7. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Anushka Chandrababu Mar 9, 2015 12:09 AM (in response to Matt Coles)Thank you so much Mathew. Your answer worked and now I am able to change tableau user to superuser.
Thank You
Anushka
-
8. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Anushka Chandrababu Mar 9, 2015 12:10 AM (in response to Vien Hua)Hi Vien,
Thanks for letting me know. This is a very specific requirement which is being used for testing purpose and will not be used in a production server.
Thank You
Anushka Chandrababu
-
9. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Jeff StraussMar 9, 2015 6:53 AM (in response to Vien Hua)
Hi Vien. Most times readonly works well for us. We never directly update the internal PG repository, however we have run across the rare occasion where it's proves useful to query pg_largeobject which readonly does not have rights.
-
10. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Matt ColesMar 9, 2015 7:22 AM (in response to Vien Hua)
Vien, just to chime in with my own use cases for needing write access to the postgresql database:
- AD group renames without losing all our permissions
- Balance schedules for subscriptions--right now I have 8 separate schedules for our 6am weekday subscription schedule because we have more than 500 to send, and they will only be processed in parallel if you run them on separate schedules. I can manually balance the number of subscriptions in each schedule in the Server interface but it's very tedious.
- We customized the behavior for the Interactor role to include download rights on the content.
- Also need the same feature as The specified item was not found. : Querying the large object data (to export workbook / datasource definitions to file in bulk for analysis)
-
11. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Jeff StraussMar 9, 2015 7:24 AM (in response to Matt Coles)
Now that I think about it more, there was one rare usecase where we did have an update. It was a bulk update of our user emails from "xxx@dotomi.com" to "xxx@conversantmedia.com" for subscriptions. It would be analogous of going from "xxx@tableausoftware.com" to "xxx@tableau.com"
-
12. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Vien HuaMar 9, 2015 4:03 PM (in response to Jeff Strauss)
Good to know how you guys use Tableau, thanks everyone!
-
13. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Tamas Foldi May 16, 2015 6:37 AM (in response to Vien Hua)readonly user does not have read access to all tables. Some of the contents stored in pg_largeobject - readonly user does not have SELECT grant on the one.
-
14. Re: Accessing tblwgadmin user in Postgres database for Tableau 9
Jeff StraussMay 19, 2015 5:54 AM (in response to Tamas Foldi)
Tamas, perhaps you figured this out already...You could signin as tblwgadmin and then do a grant readonly to the tables that you need to have access.