dbo schema / sde schema

ducksunlimited — Mon, 26 Apr 2010 20:41:54 GMT

Dear All,

I moved ArcSDE from our production server to my local desktop on which I logged on using my domain account which is a MS SQL server account with the CREATE permission.

I followed the postinstallation steps and created a TEST GDB using Windows Authentification, SDE schema, etc. However, when I connect to TEST (no matter using my domain account or SQl server accounts - SDE, Admin, etc), I found the user is always dbo, like TEST.dbo.streets. What I wanted is the SDE schema. I am sure this is something related to moving ArcSDE to my local computer. Can anybody tell me the exact reason and how can I create a SDE schema while still operating on my desktop computer?

DBMS: MS SQL server 2005
ArcSDE: 9.3
Connection: 2-tier

Thanks in advance,

Russel

dbo schema / sde schema

VinceAngelo — Mon, 26 Apr 2010 22:07:56 GMT

The ArcSDE instance metadata tables are owned by "SDE" if 1) You use the SDE user
to run the sdesetup utility, and 2) SDE is not registered as the database owner.

The data owner will be the user who loaded the data, unless that user is a member
of the Administrators role, or has otherwise been granted DBO rights, in which case
the owner maps to DBO. "Best practices" guidelines recommend reserving your
SDE schema for ArcSDE instance administration, so you you should not ever load
spatial data as the SDE user.

- V

topic dbo schema / sde schema in Data Management Questions

dbo schema / sde schema

dbo schema / sde schema