nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

GDBAdminPython2017.zip

JillianPenney

The presentation slides and demo code for the Administering your Enterprise Geodatabase using Python session at Developer's Summit, March 2017.

Find more posts tagged with

Geodatabase

Comments

YungKaiChin

Thank you for the video here Administering your Enterprise Geodatabase using Python - YouTube .

I happened to be working and tweaking a maintenance script. If I may ask a few questions here ...

In the video, I saw the the sql account used by geodatabase admin by default had all the privileges - Select, Insert, Update, Delete. It does not seem to be what I see in the geodatabases I created. I follow this ESRI document (Privileges for geodatabases in SQL Server—Help | ArcGIS Desktop), and the sde account has following previleges - Create function, Create procedure, Create table, Create view, and View definition. However, sde only has Select privilege on all the tables and feature classes that users create. My questions are: First, should sde have all 4 privileges by default? Second, what additional privilege should I grand to the sde account to make 'that' by default?
Also, is there a tool that would list all the geodatabases (excluding non-geodatabases) on a given SQL instance?

MostafaGhiyasvand1

Thank you so much.

- mostafa

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.