Is there any specific user requirement for Publishing?

[Yogesh_Chavan]

We have ArcGIS Pro 3.3, Enterprise 11.3 and SQL Server 2022.

In our SQL Databases(SDE), the data is only owned by a singe user X.

We would like to know what is the best or recommended way of publishing services from ArcGIS Pro to Enterprise?

Question: In our case as we have only one user being the data owner, should we have a new dedicated user for publishing? or is it okay to keep using the user X for publishing?

Any help on this would be appreciated!!

[simoxu]

Just jumping in to share my thoughts:

The type of permissions you need to grant depends on what type of database you are using and what type of authentication you are using to connect (database auth, or OS auth). please see the details in the following Esri doc:

https://enterprise.arcgis.com/en/server/latest/install/windows/making-your-data-accessible-to-arcgis...

At the geodatabase level, normally you'll need 3 geodatabase roles: creator, editor and reader.

creator - very few db users should be assigned this role.

editor -  only the db users who need to edit data should be assigned this role

reader -  most of the db users 

[Yogesh_Chavan]

Thank you @simoxu, for reviewing and sharing your thoughts.

In our environment this user X is only used for almost all new files creations(Dataset, Feature-classes and tables), and we have other users use the databases using windows auth, other users do not use this login, they only work with editing this data in ArcGIS Pro, or ArcGIS Portal Map Viewer.

So, its like the user X acts as admin for managing and publishing only. Whereas other users continue working on data.