ArcSDE Administrator

Question

What is the best practices for ArcSDE Administrator and DB Administrator, to have one Administrator for both ArcSDE and DB or to have two Administrators, one for ArcSDE and one for DBA on the same production server.

VinceAngelo · Answer

I worked in an environment with a dozen of DBAs, two dozen SAs (Unix and Windows
as separate specialties), and a dozen disk storage specialists, with four ArcSDE admins.

As a DBA/SA/network engineer/software developer/geodatabase admin, I've seen dozens
of role administration configurations at client sites.  They all had merit for the site, and I
found a way to get necessary work done -- It just requires coordination and cross-training
(formal or otherwise).

- V

LeoDonahue · Answer

As SDE is fully depend on Oracle, it might  be some confusing operations for the DB. such as a new table create which DB don't know about. or some indexing issues or any reason that the DB dosn't know about. What I am really looking for if any body work in environment where they had 2 Administrator and if they faced slimier or other problem like this.

But those permissions would have to be assigned to the featureclass data owner, so the DBA would know about it.  Right?

AymanSalah2 · Answer

As SDE is fully depend on Oracle, it might  be some confusing operations for the DB. such as a new table create which DB don't know about. or some indexing issues or any reason that the DB dosn't know about. What I am really looking for if any body work in environment where they had 2 Administrator and if they faced slimier or other problem like this.