Postgres & ArcSDE with multiple schemas

308
2
06-11-2014 06:18 AM
ClayHarris
New Contributor

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.

0 Kudos
2 Replies
AsrujitSengupta
Regular Contributor III
Creating a Join between data owned by two different schemas should fine work...
0 Kudos
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos