POST
|
Creating those roles would work, so that setup is valid. However, there can't be a data owner role. Roles are really just for the permissions. What makes a data owner isn't quite just permissions, but also being the owner of schema. When it comes to an enterprise geodatabase, a user must have a schema that matches their username. A data owner really should only be one user and not part of a role.
... View more
04-11-2019
08:00 AM
|
0
|
1
|
1963
|
POST
|
Yes, you should be able to use the "sa" account as the database owner. I believe anyone with the 'sysadmin' role can change other user's passwords. https://www.top-password.com/knowledge/change-sql-server-password.html
... View more
03-28-2019
11:22 AM
|
0
|
3
|
1963
|
POST
|
The "sa" account is recognized as DBO because that user has the "sysadmin" fixed server role. Since it is a headless account it would probably be easier to set this user as the database owner. DBO versus the database owner is a common confusion and something specific to SQL Server. This documents may provide some insight into the differences. https://stackoverflow.com/questions/2731787/what-is-the-difference-between-db-owner-and-the-user-that-owns-the-database https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/server-and-database-roles-in-sql-server
... View more
03-28-2019
10:38 AM
|
1
|
5
|
1963
|
POST
|
Andrew Winchell There are several ways to do this. Rhett Zufelt is correct by saying a script could be created to truncate the data in the enterprise geodatabase and then append the data from the file geodatabases to the enterprise geodatabase. https://pro.arcgis.com/en/pro-app/tool-reference/data-management/truncatetable.htm https://pro.arcgis.com/en/pro-app/tool-reference/data-management/append.htm Another option that jumps to my mind (if the data is registered as versioned) is creating Check Out replicas. http://desktop.arcgis.com/en/arcmap/latest/manage-data/geodatabases/creating-a-check-out-replica.htm\ Replica file geodatabases can be created off of the enterprise geodatabase. Then edits can occur in those file geodatabases. After the edits are done, the Synchronize Changes tool can be executed to move the edits from the file geodatabases to the enterprise geodatabase. If you aren't familiar with replicas and versioning, then doing the truncate and append should probably address your needs. All these options can be accomplished by creating a Python script that uses the geoprocessing ArcPy functions or using Model Builder.
... View more
03-27-2019
08:07 AM
|
3
|
0
|
798
|
POST
|
Jose Sanchez There is not a way to export and import versions between enterprise geodatabases. Asrujit SenGupta is correct by saying this is the same question he referenced. I see he has listed a way to export the data from a specific version and it looks like that would work. However, that would just be exporting the data from a version and you wouldn't exactly be able to import as a version into another enterprise geodatabase. The data could be appended in some sort of fashion though.
... View more
03-27-2019
06:10 AM
|
2
|
0
|
1016
|
POST
|
Vish Apte It is by design to have the SDE user owner of the DEFAULT version when working with branch versioning. However, this does not cause any problems if it is a DBO owned schema geodatabase. I believe the reason to display "SDE" as the owner is for security reasons. If "DBO" was listed then this would inform people that SQL Server is being used and this could be a security issue. Also, DBO comes with security issues in general since any user with the "sysadmin" fixed server role can become DBO. Overall, having a DBO owned schema geodatabase is supported with Branch Versioning.
... View more
03-26-2019
07:23 AM
|
3
|
1
|
3568
|
POST
|
vincenzo deriu Have you looked at the "Locks" tab in the Geodatabase Administration window? To get here: 1. Right-click on the sde connection file (using Geodatabase Administrator credentials) 2. Hover over Administration 3. Click Administer Geodatabase... 4. Click Locks tab Are there any locks listed here when this error is being received? http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-postgresql/manage-geodatabase-locks.htm
... View more
03-26-2019
06:59 AM
|
0
|
0
|
1507
|
POST
|
Paul Huffman The most important thing noted is that you still have headless account for the data owner and geodatabase administrator. This will allow you to to do many geoprocessing functions. Now in regards to running a tool like Create Database User, that does require someone with System Administrator privileges. Since you are using SQL Server, a user can be granted the server role "sysadmin". https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/server-and-database-roles-in-sql-server If a user is part of that "sysadmin" role then they have System Administrator privileges and will be able to execute tools that requires those privileges. Once a user has the "sysadmin" role then they will be known as DBO. http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/comparison-geodatabase-owners-sqlserver.htm Now, if you right-click on the database (in SSMS), go to properties, and click the General tab then you will get a window like this. Here you will see the actual owner of the database will still be your OS user. This really shouldn't have any impact when it comes to doing ESRI workflows. However, I found some Microsoft documentation that may address how to change this. https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-changedbowner-transact-sql?view=sql-server-2017 https://blog.arvixe.com/change-database-owner-with-sql-server-management-studio/
... View more
03-26-2019
05:51 AM
|
1
|
7
|
1963
|
POST
|
Murat Demircan This is a good question. Right now, it doesn't seem like sharing a geodata service with ArcGIS Pro is an option. What is the intended purpose for the geodata service? I primarily see geodata services used for replication. However, replica workflows like "Create Replica" and "Synchronize Changes" are not available with ArcGIS Pro. Tools that are not available in ArcGIS Pro—Appendices | ArcGIS Desktop
... View more
03-04-2019
09:46 AM
|
0
|
0
|
2687
|
Title | Kudos | Posted |
---|---|---|
1 | 03-26-2019 05:51 AM | |
1 | 03-28-2019 10:38 AM | |
3 | 03-26-2019 07:23 AM | |
2 | 03-27-2019 06:10 AM | |
3 | 03-27-2019 08:07 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|