I have the following intention:
Working with mySQL as underlaying DB-Provider, I have the following solution yet:
I have a database, where the login/password is handled. Each User has it’s unique database. But all database schemas are identically.
My software works the way, that after a successful login, I get back the database name. And so I can achieve, that a user always is only allowed to use it’s related data.
(I hope this is clear so far)
When I use relativity server now, is it also possible to work with a single schema, where I can change the database name (via connection string for example).
Or do I have to create a new schema for every user and must update all the schema related changes to each schema?
THX for clarification.