You always have to use one database instead of creating multiple databases. WHat you can do is when creating new user in UI, you have to give the option to see the corporation/areas where they will have permissions.
Then in Database user table, add column saying privileges/permittedarea/preferredarea something and save the user selected options. Now whenever user logins, based on his preferredarea, query the database display only those areas.
Gayathri, if this helps please login to Mark As Answer. |
Reply | Alert Moderator