DB Visibility Levels support with Postgres

[Guillaume]

Visibility Levels seem to provide a way to tweak the visible packages in EA Browser based on a Model configuration done in the Pro Cloud Server, using a dedicated DB user.
So I would expect to have a number of configs in the PCS:
Full Model
Model A
Model B

A user who can access Model A would not see all the model packages in EA.

Is all the above correct?

According to the online guide https://www.sparxsystems.com/enterprise_architect_user_guide/15.0/model_repository/visibility_levels.html, this is limited to SQL Server and Oracle as it uses the DB Row Level Security feature.
I noticed that other DBs like Postgres support this feature as well so I wonder why it's limited to 2 DBMSes.

[Modesto Vega]

Sorry to ask a very silly question but do you understand that this only applies to Pro Cloud Server and not to Enterprise Architect?

As far I understand to use PostgreSQL with Pro Cloud Server an ODBC connection is required (and the only way to connect), whilst to use SQL Server and Oracle the OLE/DB Driver needs to be used or is recommended for Oracle. It is possible that row level security cannot be used using an ODBC driver.

It would be good if somebody from Sparx System could comment on this.

[Guillaume]

Hi,

Yes, my understanding is that it works with EA when I connect to the EA DB via the PCS.
However based on this link https://www.sparxsystems.com/enterprise_architect_user_guide/15.0/model_repository/vl_config.html, this seems to require the Ultimate edition; does it apply to all the clients or only to an EA Admin (question for Sparx) ?

[Modesto Vega]

My point is/was that this setting is not applicable to Sparx EA, it is applicable to ProCloud Server which is a separate product.

Also I think that ODBC may not carry the security credentials required for row level locking to work. This is what I would like Sparx Systems to clarify.