|
POST
|
Tim, Unfortunately there is no direct tool to change Domain Owner for a geodatabase. You can try below workflow: 1. Export existing domains owned by 'X' to a table using 'Domain to Table' tool 2. Remove the existing domains owned by 'X' from the fields in the data 3. Delete the domains owned by 'X' connected as user 'X' 4. Import the domains from the tables created in step 1 using 'Table to Domain' tool connected as the "DBO" user 5. Assign newly created domains in step-4 to fields from which they were removed in step 2 This works successfully for me. However do take a backup of the geodatabase before trying this at your end OR test it on a test geodatabase and then implement it. Domain To Table (Data Management): http://resources.arcgis.com/en/help/main/10.2/index.html#//001700000022000000 Table To Domain (Data Management): http://resources.arcgis.com/en/help/main/10.2/index.html#//001700000025000000 Hope this helps!
... View more
03-22-2014
02:26 PM
|
3
|
0
|
3467
|
|
POST
|
No, I wrote that for creating/loading of new data.....not for editing existing data. For editing existing data, you just need to grant the Logins sufficient permissions either on the database (db_reader, db_writer) or on individual data (ArcCatalog privileges) However, to create/load new data using the DBO schema----you'll have to grant sysadmin to the other users. That is the reason, its advisable to create a common Login for loading/creating new data into the sde gdb and I'll suggest you the same, unless you specifically need to load it with DBO-Schema
... View more
03-21-2014
12:50 PM
|
1
|
0
|
4726
|
|
POST
|
Tim, Thats kind of an incorrect workflow that you are following....making the software believe that you are a user with DBO privileges. If you want all the users to load data as "DBO" (I believe you want this so that the naming convention in your sde gdb shows as db_name.DBO.xxx), you will have to grant them the "sysadmin" privilege (which is the highest possible privilege in SQL Server and not only grants complete access to that particular geodatabase, but any geodatabase on that SQL Server instance). Have a look at the below article from Microsoft explaining dbo and db_owner: Server and Database Roles in SQL Server: http://msdn.microsoft.com/en-us/library/bb669065(v=vs.110).aspx The dbo, or database owner, is a user account that has implied permissions to perform all activities in the database. Members of the sysadmin fixed server role are automatically mapped to dbo. The dbo user account is frequently confused with the db_owner fixed database role. The scope of db_owner is a database; the scope of sysadmin is the whole server. Membership in the db_owner role does not confer dbo user privileges. So if you want the users to load data as DBO, then you'll have to grant them the "sysadmin" server role. In SQL Server Management Studio--> Connect to Instance as a Admin user--> Instance Security--> Logins --> R-Click on the Login --> Server Roles--> Sysadmin
... View more
03-21-2014
12:09 PM
|
1
|
0
|
4726
|
|
POST
|
Jill, According to the description provided under "Specifying how user names are recorded" in the below link, this should not be occurring if your user is always using lower-case to login. About tracking an editor's changes to data: http://resources.arcgis.com/en/help/main/10.1/index.html#//01m600000068000000 Maybe you can suggest them to try creating a new connection, just to check if the behaviour is reproduced.
... View more
03-21-2014
11:15 AM
|
0
|
0
|
899
|
|
POST
|
Tim, You don't really need the db_owner to create/load data in that sde geodatabase. The following permissions will suffice as well: CREATE FUNCTION CREATE PROCEDURE CREATE TABLE CREATE VIEW To check what permissions your login has right now, Connect to the Instance in SQL Server-->R-Click on the database-->Permissions-->Select your user from the list-->Effective----This will list all the permissions that the login has on that database User privileges for geodatabases in SQL Server: http://resources.arcgis.com/en/help/main/10.1/index.html#//002q0000002s000000
... View more
03-21-2014
11:03 AM
|
0
|
0
|
1210
|
|
POST
|
Tim, As mentioned in the below link, "Remember, the user name and schema name must be the same if this user is going to own data." -- Point #14 Adding database-authenticated logins to a SQL Server database: http://resources.arcgis.com/en/help/main/10.2/index.html#//002q0000002m000000 Instead of trying to match the username with the Default Schema assigned by Microsoft SQL Server (which is dbo)....you simply need to match the 'Default Schema' with the username ( if username is X--> the default schema should be X as well) If a Login has been granted "sysadmin" privilege, it automatically becomes a DBO and its schema is taken as 'dbo'. NOTE: This is same for both DBO-Schema and SDE-Schema geodatabases.
... View more
03-21-2014
10:54 AM
|
0
|
0
|
4726
|
|
POST
|
Tim, The error comes up when the Schema does not match with the username for that Login In SQL Server Management Studio--> Connect to Instance--> Instance Security--> Logins --> R-Click on the Login being used to copy over the data --> User Mapping --> Confirm that the 'Default Schema' matches the username! If the user is part of the "sysadmin" role under the "Server Roles" we don't need this, otherwise the Default Schema and User should match. Microsoft grants 'dbo' automatically by Default, and we need to change that manually.
... View more
03-21-2014
08:24 AM
|
3
|
6
|
9447
|
|
POST
|
It always helps if you provide the configuration details (atleast the version of ArcGIS Desktop in this case) HowTo: Connect to Microsoft Access 2007/2010 (ACCDB) files in ArcGIS: http://support.esri.com/fr/knowledgebase/techarticles/detail/32976 HowTo: Use Microsoft Access tables in ArcGIS: http://support.esri.com/en/knowledgebase/techarticles/detail/30770 Connecting to a Microsoft Access database in ArcGIS: http://resources.arcgis.com/en/help/main/10.1/index.html#//005s00000023000000
... View more
03-12-2014
03:01 PM
|
0
|
1
|
1100
|
|
POST
|
I would directly suggest discussing this with ESRI Tech-Support for better troubleshooting.
... View more
03-06-2014
07:35 AM
|
0
|
0
|
1176
|
|
POST
|
These links may help: Example: Discovering domain usage using SQL http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//006z000000t9000000 List Fields and Associated Domains http://forums.arcgis.com/threads/60025-List-Fields-and-Associated-Domains-gets-stuck-on-one-table-why Find fields for domain in SDE 10 http://forums.arcgis.com/threads/4625-Find-fields-for-domain-in-SDE-10
... View more
03-05-2014
11:30 AM
|
2
|
2
|
1368
|
|
POST
|
Copy that Feature Class to a File gdb and run 'Check geometry" tool on that. It should list all the features with invalid geometries. Then you can either go through the features reported in this and correct them OR run the "Repair Geometry" tool, which will repair these. Then copy this corrected FC back into the postgreSQL database and try again. However I would suggest you read about these tools a bit before executing them! Checking and repairing geometries: http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000042000000 Check Geometry (Data Management): http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000034000000 Repair Geometry (Data Management): http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000003v000000
... View more
03-03-2014
12:30 PM
|
0
|
0
|
837
|
|
POST
|
simply stated the "process_admin" server role along with db_owner should be sufficient!
... View more
03-03-2014
12:24 PM
|
0
|
1
|
2633
|
|
POST
|
Vikram, To disconnect users, the geodatabase administrator may need additional privileges. The geodatabase administrator (sde) in an sde-schema geodatabase requires VIEW DEFINITION privileges on the database to see the list of connected users, and must be a member of the processadmin fixed server role to disconnect users. If the geodatabase administrator of a dbo-schema geodatabase is the database owner, the geodatabase administrator must be added to the processadmin fixed server role to disconnect users. No additional privileges are required for the geodatabase administrator in a dbo-schema geodatabase if the geodatabase administrator is a member of the sysadmin fixed server role. Removing connections from a geodatabase in SQL Server: http://resources.arcgis.com/en/help/main/10.1/index.html#//002q000000r8000000
... View more
03-03-2014
12:18 PM
|
0
|
0
|
2633
|
|
POST
|
Remark: At the moment, there is no GEOPROCESSING tool that can create replica from the enterprise gdb to the file gdb. 1. The �??create replica�?� tool doesn�??t allow tables (non-spatial data) to participate in the replica 2. The �??create replica�?� of tool bar requires adding all the layers of the enterprise gdb to the ArcMap to create the replica. This is itself a headache What I�??m looking for is one single tool that can take all the updates from the source to the destination IN ONE GO. This tool is supposed to: 1. Delete the existing file gdb (destination) 2. Create new replica between the enterprise gdb (source) and the file (destination) Jamal, You can surely complete the above task, but not with ONE single tool! You can use the 'Delete' tool to delete the File geodatabase and then use the below workaround to create the Replica. >>Create a model using the 'Make Table View' and the 'Create Replica' tools. > Pass the standalone table to the 'Make Table View' tool and set a filter in the expression. eg. Objectid>=1 can be used if the entire table is being replicated. > Pass the output of the 'Make Table View' to the 'Create Replica' tool and define the various parameters. Reference: Create Replica on SDE Table: http://forums.arcgis.com/threads/48195-Create-Replica-on-SDE-Table?p=166604#post166604 However, I am not sure if this will help, as you will have to manually "Unregister the Replica" to create another replica with the same name.(or you'll have to manually change the replica name everytime to a new one) As Marco pointed out, the NIM seems to be fixed in an upcoming release, so you should be able to synch more than 1000 records (features) deleted. Regards,
... View more
02-24-2014
11:50 AM
|
0
|
0
|
1678
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 09-14-2015 09:19 AM | |
| 1 | 06-17-2013 11:43 AM | |
| 3 | 03-21-2014 08:24 AM | |
| 1 | 03-22-2016 03:04 PM | |
| 1 | 09-29-2015 09:47 AM |
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:23 AM
|