AnsweredAssumed Answered

Allow users to access some database versions only.

Question asked by Reda20 on Apr 2, 2014
Latest reply on Apr 2, 2014 by geonetadmin
Hi everyone !

I have 2 questions about Database versioning:

1. Is it normal where you drag and drop a feature class/dataset, it gets assigned as a dbo.DEFAULT version even if the user connected is not supposed to access it ? What I am missing here through my versions creation is maybe how to assign a version exclusively to a user? please advice! (Ref. users not dbo.png)

2. (Related to 1) Is it normal that the same connected user(who is not the Database Administrator(dbo)) as simple user has the right to switch between versions ?What if the dbo doesn't want him to do it? What is the procedure? (Ref. switchversions.png)
and even after switching to the version assigned to the user, he could switch to dbo.DEFAULT which is a I think a task that should be exclusive to the database administrator only... Please kindly advice !

Important Notes/Technical Spec.:
- ArcGIS Desktop 10.1 SP1/SDE.
- Users/permissions configured/managed from MS SQL Server 2008 R2 and not from ArcGIS Desktop.
- Versions created successfully.
- All users versions have been created as Protected versions.