Hi all!
I have one ArcSDE Geodatabase, user 'sa' is owned Default version. I create a new version (in arccatalog) and privilege user sa1 permission are delete, update, insert to this new version.
When i connect to database in arccatalog by user sa1, i can edit new version but can't edit default version. But why I connect to database directly in SQL Server by user sa1, I can edit data in database? That' mean: user sa1 can not edit on ArcMap but can edit in SQL?
I want to create a user only edit on new version (on ArcMap) but can not edit data by connect to sql (as user sde).
Help me!
I have one ArcSDE Geodatabase, user 'sa' is owned Default version. I create a new version (in arccatalog) and privilege user sa1 permission are delete, update, insert to this new version.
When i connect to database in arccatalog by user sa1, i can edit new version but can't edit default version. But why I connect to database directly in SQL Server by user sa1, I can edit data in database? That' mean: user sa1 can not edit on ArcMap but can edit in SQL?
I want to create a user only edit on new version (on ArcMap) but can not edit data by connect to sql (as user sde).
Help me!
I'll suggest that you go through the Web-Help docs for a better understanding of Versions, Access Level of Versions, User Permissions, etc.
What is a version?
http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000tq000000
A quick tour of versioning:
http://resources.arcgis.com/en/help/main/10.2/index.html#//003n000000t7000000
Permission for editing in a version and permissions to edit data from the SQL Server have no link at all!
This is applicable only while editing the data in the ArcGIS interface and not from database end.
If you want to restrict the user from editing data from SQL Server, grant only CONNECT from database end and then grant privileges on the data to be edited from the Desktop interface. Check if this helps!