Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: Jacob Vos on February 18, 2022, 01:34:59 am

Title: Other user cannot connect to EA repository set up in Postgres
Post by: Jacob Vos on February 18, 2022, 01:34:59 am

I set up a repository in a Postgres db. When another user connects to the database, he gets the message that all EA tables are missing in the repository.

It's because I used my user account when creating the EA tables. The tables are owned by me.

What's the best practice for this? Namely in a situation where several users have an own account in the DBMS?

The helptext (https://sparxsystems.com/enterprise_architect_user_guide/15.2/model_repositories/upsizingtopostgresql.html)  doesn't say anything about it.

Title: Re: Other user cannot connect to EA repository set up in Postgres
Post by: Jacob Vos on February 19, 2022, 01:58:25 am

The way we solved it: reassign ownership of the tables to a group with at least CRUD rights on the tables, and make all individual users member of this group.

So a common way to deal with such authorization issues.