Create SDE Schema Enterprise Geodatabase in Azure SQL database
https://medium.com/@chakresh_sahu/create-sde-schema-enterprise-geodatabase-in-azure-sql-database-7e0be4b293e9
Successful completion of database creation. 6. Verify permissions for user SDE in database.. Right-click the database in which the user was applied > Properties. · Select Permissions from the top …
How To: Create an SDE schema geodatabase using the Enable Enterprise …
https://support.esri.com/en/technical-article/000011998
If there is a need to have the schema owned by the SDE user, the instructions provided describe the steps to set this up by setting up the SDE login/user within the database with proper permissions, and then making a connection to the database as the specific SDE user to implement the Enable Enterprise Geodatabase tool.
Solved: DBO or SDE or what schema? – Esri Community
https://community.esri.com/t5/data-management-questions/dbo-or-sde-or-what-schema/td-p/340010
If you choose to go with a sde schema, the sde user will never and should not load data into the geodatabase. All of your ArcSDE related tables will be prefixed with « sde. » But you are free to create other SQL Server accounts with the correct permissions to perform the role of data loading.
What is ArcSDE? | GEOG 868: Spatial Databases
https://www.e-education.psu.edu/spatialdb/l5_p3.html
ArcSDE is software that enables ArcGIS applications to store, manage and retrieve data in a RDBMS. The « Arc » comes from the ubiquitous naming convention used by Esri for their products. The SDE part stands for Spatial Database Engine. ArcSDE is sometimes described as middleware, a layer of software that sits between Esri’s ArcGIS products …
PDF Understanding ArcSDE – Esri
http://downloads.esri.com/support/documentation/sde_/706understanding_arcsde.pdf
specific DBMS schema used to represent various geographic datasets and for domain-specific logic, which maintains the integrity and utility of the underlying records. In effect, the DBMS is used as an implementation mechanism for geographic datasets. ArcSDE is part of the multitier architecture (application
A comparison of geodatabase owners in SQL Server – Esri
https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/comparison-geodatabase-owners-sqlserver.htm
The sde user must have authority on a schema named sde, and that schema must be the sde user’s default schema. The sde user also must be granted privileges in the database that allow the user to create and administer the geodatabase. The dbo user The dbo user and its default schema exist in all databases automatically.
A comparison of geodatabase owners in SQL Server—Help – Esri
https://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/comparison-geodatabase-owners-sqlserver.htm
The sde user in a database can be associated with a SQL Server-authenticated login or a Windows-authenticated login. The sde user must have authority on a schema named sde, and that schema must be the sde user’s default schema. The sde user also must be granted privileges in the database that allow the user to create and administer the geodatabase.
Creating data in an ArcSDE geodatabase under a different schema
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8427cab5-268e-4038-a85c-121827ef10c9/creating-data-in-an-arcsde-geodatabase-under-a-different-schema?forum=sqlsecurity
Now, with some work, i managed to allow a user to create data, but the schema is not dbo, but their username (e.g. database.username.featureclass. How do I get Sql server login Domain\username to be able to create data in the geodatabase in the format that currently exists (i.e. database.dbo.featureclass) ?
Privileges for geodatabases in SQL Server—Help | ArcGIS Desktop
https://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/privileges-sqlserver.htm
The geodatabase administrator (the sde user) in an sde-schema geodatabase must be added to the processadmin fixed server role and granted VIEW DEFINITION privileges on the database to drop geodatabase connections. The Create Enterprise Geodatabase geoprocessing tool grants this role and privilege to the sde user.
SDE schema – Mastering ArcGIS Enterprise Administration [Book]
https://www.oreilly.com/library/view/mastering-arcgis-enterprise/9781788297493/3329e044-8475-4191-8a02-231b6750f63c.xhtml
SDE schema To create an enterprise geodatabase with an sde schema, you will configure and execute the Create Enterprise Geodatabase tool like the following: Here, we will specify the sa account and the sde account. When we specify that we want an sde-owned schema, the Geodatabase Administrator textbox gets prepopulated with sde.