[LEFT]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.[/LEFT]
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