https://community.esri.com/t5/data-management-questions/post-to-default/m-p/1388144#M44989 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/191610">@JohnForce</a>&nbsp;</P><P>You can try to grant "db_owner" to the other user and it shall be able to post to sde.default.</P><P>Note, move away from DBO and use instead the ArcSDE Repository owned by a user named "SDE", this allows a much better security configuration.</P><P>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.</P><P><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351" target="_blank" rel="noopener">Mapping and Charting Solutions (MCS) Enterprise Da... - Esri Community</A></P> Wed, 28 Feb 2024 17:03:45 GMT MarceloMarques 2024-02-28T17:03:45Z https://community.esri.com/t5/data-management-questions/post-to-default/m-p/1387882#M44987 <P>Is it possible for a non-DBO account to post to a DEFAULT version of the SDE?</P><P>Currently only one account the DBO (which is a user account) posts to our DEFAULT database version</P><P>This creates a bottleneck when the user is unavailable or engaged</P> Wed, 28 Feb 2024 07:03:53 GMT https://community.esri.com/t5/data-management-questions/post-to-default/m-p/1387882#M44987 JohnForce 2024-02-28T07:03:53Z https://community.esri.com/t5/data-management-questions/post-to-default/m-p/1388144#M44989 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/191610">@JohnForce</a>&nbsp;</P><P>You can try to grant "db_owner" to the other user and it shall be able to post to sde.default.</P><P>Note, move away from DBO and use instead the ArcSDE Repository owned by a user named "SDE", this allows a much better security configuration.</P><P>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.</P><P><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351" target="_blank" rel="noopener">Mapping and Charting Solutions (MCS) Enterprise Da... - Esri Community</A></P> Wed, 28 Feb 2024 17:03:45 GMT https://community.esri.com/t5/data-management-questions/post-to-default/m-p/1388144#M44989 MarceloMarques 2024-02-28T17:03:45Z