AnsweredAssumed Answered

db_owner vs administrator privileges

Question asked by Wolseley on Jul 24, 2017
Latest reply on Jul 25, 2017 by asrujit_pb

I am using ArcGIS 10.2.2 with SQL Server 2008 R2. I am using Database Authentication. I do not want the people who connect to our Enterprise Geodatabase to connect using the administrator username and password. I have them connect using their standard network login credentials such as when they login into their work PCs to get onto the network. 


Like the rest of my users, I log in using my standard network credentials (not the administrator username and password). I have been assigned the Privilege (done using SQL Server Management Studio) db_owner. But, when I go into ArcCatalog and right click on a Feature Dataset - Manage, all the options are grayed out (see attached). However, when I log in with the Administrator username and password, these same options are NOT grayed out. 


An ideas? I was under the assumption that db_owner has the necessary privileges to do the what is shown under Manage, such as Analyze, Add Global IDs, Register as Versioned, Unregister as Versioned, etc...