topic Re: Postgres & ArcSDE with multiple schemas in Data Management Questions

Postgres & ArcSDE with multiple schemas

ClayHarris — Wed, 11 Jun 2014 13:18:41 GMT

I want to create a separate Postgres schema for "business" data, providing a logical separation of SDE schema from business data from various other sources that tend to be non-spatial. I do, however, want to be able to perform a join on tables within the business schema with SDE. From the context of using ArcSDE, is this going to be problematic or is there another design pattern that I should employ to logically separate data.

Re: Postgres & ArcSDE with multiple schemas

AsrujitSengupta — Wed, 11 Jun 2014 13:40:37 GMT

Creating a Join between data owned by two different schemas should fine work...

Re: Postgres & ArcSDE with multiple schemas

VinceAngelo — Wed, 11 Jun 2014 13:59:54 GMT

The only issue I've encountered is that, if you choose to create a view across two or more
schemas, the user which will own the view must have at least SELECT access "WITH GRANT
OPTION" on the tables which will be joined. If you use an ArcGIS join, relate, or relationship
class, then the user only needs SELECT access.

- V