Reg : Preventing user to load data in Production Database (SQL Server

Discussion created by svikram86 on Nov 11, 2013
Latest reply on Nov 12, 2013 by ldonahue
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

  • 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 ?