Forum Discussion
Post PartisanMultiple Customer Solution in fabric
Hi DiKi-I,
I think this really depends on the business requirements here. I would not make a new mirrored DB for each user, that seems to be a little much.
What's the security requirements? Are all users access the same data, or are they each accessing different data from the same database?
Where my mind immediately goes for this is to have one workspace that contains the database, and then the users all connect to that same database in their workspaces.What could also work is one mirrored DB and then a lakehouse with shortcuts to the mirrored database.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Super UserHi DiKi-I,
I think this really depends on the business requirements here. I would not make a new mirrored DB for each user, that seems to be a little much.
What's the security requirements? Are all users access the same data, or are they each accessing different data from the same database?
Where my mind immediately goes for this is to have one workspace that contains the database, and then the users all connect to that same database in their workspaces.
What could also work is one mirrored DB and then a lakehouse with shortcuts to the mirrored database.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.