In my application, I have a separate database for each instance (let’s call it client portal) and that’s fine, and it’s exactly how I want it to be, but the rights tables I’d like to move to a central db instead of having to update each database each time i have to make a new set of roles/tasks, etc.
Has anyone done this or does anyone have an idea how I can do handle this?
Thanks in advance.