Cannot create feature class in a schema other than sde

GIS123EXPERT

Hi, I have a user other than sde ( example :view_user) and I want to create a new featureclass in Postgresql sde with view_user.

I set the owner of sde as view_user .After setting the necessary permissions on the Postgresql side, I was able to edit the existing data, but I cannot create a featureclass for the sde. As you can see in the attachment, I get the error "database user name and current user schema do not match".

When I add a enterprise geodatadase from ArcGIS Pro, it automatically adds it to the application with the sde schema. Is it possible to call a schema other than the sde schema in ArcGIS Pro?

How can we ensure that different users in the database can open featureclasses?

 

Regards.

error.png

RussRoberts_0-1740415370818.png

George_Thompson

We do NOT recommend loading data as the SDE user and would create a separate DB user / schema to own the data: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/add-users-postgresql.htm

That error message "database user name and current user schema do not match" is expected, see the doc link above.

You them grant other users permissions to view and / or edit: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/privileges-postgresql.htm

Hope this helps!