Author Topic: Other user cannot connect to EA repository set up in Postgres  (Read 2541 times)

Jacob Vos

  • EA User
  • **
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Other user cannot connect to EA repository set up in Postgres
« 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.

Jacob Vos

  • EA User
  • **
  • Posts: 108
  • Karma: +0/-0
    • View Profile
Re: Other user cannot connect to EA repository set up in Postgres
« Reply #1 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.