Hi-- we use Tableau with a MySQL database at our work and each employee has a personal Schema associated to his account (with personal credential). In the example below, in the report I'm using the table 'Account' with the Schema 'dwh_fc94886', when I publish the work book, employees can't access it as my personal schema is associated.
Is there an option to un-link my schema ? Then, each employee can connect with its personal. We use personal schema but generic tables, user's rights are manager at schema level.
Thanks
How about UNIONing all schemas and using user filters to show only data related to the logged in users ? The UNIONed data source could be published and as one entity with necessary refresh schedules.
Create a User Filter and Secure it for Publishing
Restrict Access at the Data Row Level
Hope it helps. Good Luck !!
VG