Skip to main content
Geographic Information Systems

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

5
  • Just to be sure, that table was created by the sde user? Does it say sde.ecofield in the catalog window?
    – Berend
    Commented May 28 at 20:06
  • The database name is "ecofield.sde", and the table name is "ecofield.shape_test.counties". Because it is a PostreSQL connection, I believe "shape_test" is the schema name, and the "counties" is the table name. How can I check the owner of a table.? The first image I upload shows the owner of the enterprise connection. Would it happens that the table's owner is not the same as the database owner?
    – kgs-tliu
    Commented May 28 at 20:17
  • In that case, it looks like shape_test is the schema / owner. Can you login as shape_test?
    – Berend
    Commented May 28 at 20:36
  • But "shape_test" is a schema, there is no password for it. I cannot login with a username: "shape_test"
    – kgs-tliu
    Commented May 28 at 20:52
  • Yes, you are right. The owner should be shape_test. Just I am quite new to GIS, it was hard for me to understand to login as a schema. Thanks for your solution
    – kgs-tliu
    Commented May 29 at 14:36