We have set up an Enterprise GDB using ArcGIS 10.6 and PostgreSQL 10.5, and would like to create users can view and edit data, but not creating data. So we followed the instructions at Add login roles to PostgreSQL—Help | ArcGIS Desktop and got some questions.
1. There is a schema "geodata" referred in the instruction, but clearly it is not a built-in schema and I could not find what it refers to. Could someone clarify it for me?
2. Instead of granting "geodata", we continued with granting "sde" to the user. However, the new editor user could not see the feature class after the feature class has been granted privileges through Manage->Privilege.
3. We did not alter the sde schema privilege, but if I add PUBLIC to the feature class, then the editor user can see the feature class.
4. What is the best practice for the PUBLIC schema?
Thanks in advance!
Siyu