AnsweredAssumed Answered

Minimum privileges for table in enterprise geodatabase

Question asked by fallingdog on Mar 6, 2018

I used the import table multiple tool in ArcCatalog when logged in as the owner that I wanted the new tables to be under. Then I granted our general gis user role to the table. When looking at the sql for the table I noticed that sde had no privileges on the new tables. We were under the impression that sde was granted to everything automatically by esri; however, the data shows up fine when I log in with OSA as a low level user...

 

So, I am wondering if we are good to go without the sde grant. And are there any grants that are missing that we should be concerned about. Like SYS? 

 

Orical 11g

Enterprise Geodatabase is 10.1

ArcCatalog 10.1

Outcomes