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.

KurtisGagne1_0-1661806334749.jpeg

Find more posts tagged with

Geodatabase

Comments

MostafaGhiyasvand1

Thank you so much.

- mostafa

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?

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.