I've read somewhere that it is not good practice to load data into an enterprise geodatabase using the sde user.
I was wondering what the reason for this is?
administrationarcgis-serverenterprise-geodatabase
I've read somewhere that it is not good practice to load data into an enterprise geodatabase using the sde user.
I was wondering what the reason for this is?
Best Answer
The ArcSDE administrative user (sdeuser) account is responsible for the administration of the following:
The ArcSDE administrator owns all the ArcSDE geodatabase system files, directories, and tables. For this reason, the ArcSDE administrative account must be created before the geodatabase can be created. The database administrator (DBA) creates the ArcSDE administrator and grants this user the necessary permissions. On Windows installations, this can be accomplished through the Post Installation wizard. On UNIX/Linux, this is done manually, and how it is done depends on the operating system and database management system (DBMS) you are using.
All other users must be GRANTED Permissions on their accounts to load/change/delete data.
Key to this is:
Full Documentation: http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/user_pe-564470524.htm