On our ArcGIS Enterprise 11.5, I installed latest PostgreSQL 16.8 as geodatabase (with ST_geometry).
I've set several role/schemas to manage dedicated features datasets and classes (e.g. : Hydrology gets water, rainfalls, etc... ; Mobility gets road signs, one-way roads, etc...).
One common role/schema is called "basepack" and is dedicated to basics assets (datasets and tables) that every users may need, to help brainstorming their projects.
These assets should be added to usual user's projects but only editable by SDE (dedicated to GIS Management).
Summary :
- SDE => usage/manage users, schemas and basepack;
- USUAL USER => manage its own data + usage basepack;
- BASEPACK : as is
I've tried lots of config with security, privileges etc ... but everytime I connect users, they can see all tables from each others with the only limitation to be able to edit or stay read-only.
It's really confusing for the final users to have such a bunch of mixed assets, restricted or not.
It would be way much cleaner to have such a config :
- SDE : See all datasets, feature classes, etc ... (with full edit capabilities)
- USUAL USER : See their assets only (with full edit capabilities) + those of basepack (read only)
- BASEPACK : See it's own assets only (with full edit capabilities)
I would like to have SDE user/schema control over all users/schemas
Long story short : Is it possible and how do I configure it with roles/schemas : sde, mobilite and basepack for basic example ?
Any help would be appreciated.
Have a nice day.
