Hello all,
I have ArcSDE 10.2 and SQL Server 2012 . Windows Authentication to connect to the database . I would like to prevent users from adding data into production geodatabase . Currently whenever the user adds the data it gets added with the schema name same as windows login (domain\username.featureclassname)
How can I make sure only the
How to achieve this ?
Thanks
I have ArcSDE 10.2 and SQL Server 2012 . Windows Authentication to connect to the database . I would like to prevent users from adding data into production geodatabase . Currently whenever the user adds the data it gets added with the schema name same as windows login (domain\username.featureclassname)
How can I make sure only the
- data loaders have access to load feature class or create new feature class
- data editors has access only to edit the existing feature class and not to create new feature class?
How to achieve this ?
Thanks
For a more comprehensive overview of recommended database privileges:
User privileges for geodatabases in SQL Server
Regardless of which user has create table, you will still have layers added with a schema of domain\username.featureclassname.
As the SDE admin, you should be the one who loads data, but don't use the SDE account to load data. Create a headless sql account and only load data with that user, then at least you have control over the schema names of your layers. The name could be the name of your division or organization, etc.