FrontAccounting forum — User permission for each company/database

Re: User permission for each company/database

null@example.com (apmuthu) — Fri, 07 Sep 2018 16:27:37 +0000

FA is multi tenant. You can choose to hos each company in a separate database or use different table prefixes and place them in the same table. Each "tenant" is then chosen in the login screen. The FA code is just a single instance but each company has it's own folder for it's data files.

If you create User A in both companies with same / different passwords, FA will accept that as well, since the users table is different for each company (with either different table prefixes in the same database oand/or different databases).

Re: User permission for each company/database

null@example.com (chunket) — Thu, 06 Sep 2018 02:06:00 +0000

Yes. I was asking for FA user and company instance. Because I notice it is currently single tenancy design. I'm wondering is there any plan to enhance to multi tenancy design? So that I don't have to create many database for companies.

https://www.netsolutions.com/insights/5-reasons-why-you-should-choose-multi-tenant-architecture-for-your-saas-application/

Re: User permission for each company/database

null@example.com (apmuthu) — Wed, 29 Aug 2018 17:26:59 +0000

This is clearly a FA user and company instance. The login system uses the company name from the $db_connections array in config_db.php file. The login user and password come from the appropriate database's users table.

Re: User permission for each company/database

null@example.com (stefan) — Wed, 29 Aug 2018 11:18:04 +0000

Is this question about FA user or about DB user? If DB user, you can do it only if you use databases with no prefix.

Re: User permission for each company/database

null@example.com (kvvaradha) — Wed, 29 Aug 2018 10:31:02 +0000

Sofar, the Login system is different for each company. You can create similar login credentials for both company and access it. But if you want to switch to other company, you need to logout and login again by selecting the second company from the login screen.

User permission for each company/database

null@example.com (chunket) — Wed, 29 Aug 2018 08:27:27 +0000

Hi, I have created 2 company in different database. How can I create a user A who can only access company A and user B to access company B? Thanks.