What users?

[eauser123]

Hello,

We have freshly installed EA 7.1 and created a postgres repository database. Our requirement is that a group of people will be working on EA simultaneously and access the database via EA.
Question is how many user accounts we should create on the PostgreSQL repository database? Different userids for each user or a single userid for everyone?
Please suggest.

Thanx,
eauser

[Geert Bellekens]

We are working on an SQL Server database and we use windows authentication for the database access.
So each user has its own access.
If you don't care too much about the EA database security I guess you have enough with one user.

Geert

[eauser123]

Thanx for the reply. But maybe I want to know more on this.
Like when few people simultaneously work on EA with same userid , how EA & database handles it? Like who so ever gets the preference while actual update/change in the database or so?
       or when every person has their account how they will be able to corelate their work in the database?


Thanx,
eauser

[Geert Bellekens]

I think the database just uses an optimistic locking principle. The same user, or a different user doesn't really matter if that is the case.

If you have worries about conflicts you can always setup security (with the option "require lock to edit") or integrate with version control.

Geert