Post to DEFAULT

198
1
02-27-2024 11:03 PM
JohnForce
New Contributor II

Is it possible for a non-DBO account to post to a DEFAULT version of the SDE?

Currently only one account the DBO (which is a user account) posts to our DEFAULT database version

This creates a bottleneck when the user is unavailable or engaged

0 Kudos
1 Reply
MarceloMarques
Esri Regular Contributor

@JohnForce 

You can try to grant "db_owner" to the other user and it shall be able to post to sde.default.

Note, move away from DBO and use instead the ArcSDE Repository owned by a user named "SDE", this allows a much better security configuration.

For more best practices, read my database guide books and database template scripts for SQL Server in the link below, see the Production Mapping, those are generic and can be applied to any industry.

Mapping and Charting Solutions (MCS) Enterprise Da... - Esri Community

| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov
0 Kudos