What do you name your Geodatabase Administrator account?

Question

We are migrating our enterprise geodatabases and will be creating a new Geodatabase Administrator account.

What do you all have your Geodatabase Administrator account named? I'm curious how other organizations handle their naming conventions.

Also, how do you handle Shared User accounts for departments (DEPT1_ADMIN, DEPT2_ADMIN, etc)

VinceAngelo · Answer

Because the admin username if half the authentication pair to obtain administrative access to the server, it's probably not a good idea to publicize what is used currently, or what it might be in the future.

I suggest using something that makes sense for your organization, with "adm" or "admin" or "root" or "boss" in there somewhere, but going out of your way to not use the admin naming pattern used in training. You should, of course document this adequately, potentially in a locked cabinet to which management has a key, just in case.

The exam writing consultants hate the name "headless user", but I find it, from a security standpoint, better than publishing all data as user "BobJones" since he was the admin eight years (and three admins) ago. The publishing credentials should be closely held as well (and archived in the boss' lockbox), but not as closely as full-on admin privileges.

- V

MMBR · Answer

the geodatabase arcsde repository owner is named "SDE" and the data owner users shall have short names that usually describe the schema that the data owner user has, e.g. elec for electric, any other naming conversions can be created as long as the data owner name is short, I'd recommend no more than 10 characters.

For more best practices visit my community.esri.com blog below.

Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices

* Database Connections Best Practices
* Enterprise MCS Databases Best Practices