# The use of Databases in Tryton - Many Organizations - Many years
**URL:** https://discuss.tryton.org/t/the-use-of-databases-in-tryton-many-organizations-many-years/2778
**Category:** User
**Tags:** accounting
**Created:** [May 26, 2020, 3:36pm UTC](https://discuss.tryton.org/t/the-use-of-databases-in-tryton-many-organizations-many-years/2778 "2020-05-26T15:36:36Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@alch](https://discuss.tryton.org/u/alch)
#### Post date: [May 26, 2020, 3:36pm UTC](https://discuss.tryton.org/t/the-use-of-databases-in-tryton-many-organizations-many-years/2778/1 "2020-05-26T15:36:36Z")
how are databases set up for many organizations/businesses (also for many accounting years in each) ? Are there many databases installed, or can one login to one database handle many organizations and handle many years?
---
### Author:  [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [May 26, 2020, 5:16pm UTC](https://discuss.tryton.org/t/the-use-of-databases-in-tryton-many-organizations-many-years/2778/2 "2020-05-26T17:16:05Z")
> [@alch](#):
>
> Are there many databases installed, or can one login to one database handle many organizations and handle many years?
You can use a database for multicompany or a single database for each company. It depends on how you setup and the requirements (if data should be shared, if all companies use the same set od modules, etc.)
---
### Author:  [@alch](https://discuss.tryton.org/u/alch)
#### Post date: [May 27, 2020, 2:24am UTC](https://discuss.tryton.org/t/the-use-of-databases-in-tryton-many-organizations-many-years/2778/3 "2020-05-27T02:24:25Z")
Thank you. What can you say about the accounting for many years in each company? Each fiscal year should have one database?
---
### Author:  [@alch](https://discuss.tryton.org/u/alch)
#### Post date: [May 27, 2020, 2:24am UTC](https://discuss.tryton.org/t/the-use-of-databases-in-tryton-many-organizations-many-years/2778/4 "2020-05-27T02:24:56Z")
If we use many companies in one database, can we then give different access rights per each company?
---
### Author:  [@josesalvador](https://discuss.tryton.org/u/josesalvador)
#### Post date: [May 27, 2020, 5:33am UTC](https://discuss.tryton.org/t/the-use-of-databases-in-tryton-many-organizations-many-years/2778/5 "2020-05-27T05:33:19Z")
No. All the fiscal years remain in the same database.
---
### Author:  [@pokoli](https://discuss.tryton.org/u/pokoli)
#### Post date: [May 27, 2020, 5:56am UTC](https://discuss.tryton.org/t/the-use-of-databases-in-tryton-many-organizations-many-years/2778/6 "2020-05-27T05:56:52Z")
> [@alch](#):
>
> Each fiscal year should have one database?
No, each fiscalyear should be on the same database as we need to comulate balances from previous fiscalyears in order to have correct accounting values.
> [@alch](#):
>
> can we then give different access rights per each company
Of course, you can have some users that only access one company but others that access all companies.
---
### Author:  [@SISalp](https://discuss.tryton.org/u/SISalp)
#### Post date: [May 27, 2020, 7:47am UTC](https://discuss.tryton.org/t/the-use-of-databases-in-tryton-many-organizations-many-years/2778/7 "2020-05-27T07:47:24Z")
If you manage several companies in a single database, you must
- manage access rights across more complexity
- synchronize maintenance of all companies
- keep it centralized for all life cycle
You should have a good reason to go that way.