AnsweredAssumed Answered

What privilege is given to the SDE user that allows them to bypass when a database isn't accepting connections

Question asked by N.Alexandrou on Mar 1, 2017
Latest reply on Mar 1, 2017 by N.Alexandrou

Hi everyone, 

 

I'm trying to figure out what privileges (we are using SQL), is assigned to the SDE user that allows them to bypass when a database isn't accepting connections? 

 

We have a "headless" data owner, and I would like to assign the same privilege to them so that when I am running nightly scripts and have to index and analyze datasets, I don't have to keep dropping the owner connection to index system tables, then allowing connections so the owner can rebuild indexes on all the actual data tables and delta tables.

 

Is it because SDE is a member of the processsadmin fixed server role and granted VIEW DEFINITION on the database? 

 

Is that what the data owner should be a member of? We only use the data owner account strictly for owning data. We do not use the owner account, or the SDE for anything related to publishing services, so no web services will constantly be pinging the database when I'm trying to perform maintenance. 

 

 

Thanks!

Outcomes