wilsonl

SDE with multiple schema (geodatabase) issue

Discussion created by wilsonl on Jun 9, 2014
Latest reply on Jun 9, 2014 by sthorne-esristaff
Hello,

We are having issue setting up SDE with multiple schema (geodatabase)

Here's the situation:
We have 2 SDE oracle instances TEST and PROD
For each instance, there are multiple geodatabase/schema.

For the TEST SDE.
We have AA, BB and CC schema
When I connect as AA user with BB schema selected. I don�??t see any �??FEATURE DATASET�?� in ArcCatalog
(please note, BB didn�??t give any permission to AA to �??select�?�, �??view�?��?�any dataset that BB created)


For the PROD SDE.
We have AA, BB and CC schema
When I connect as AA user with BB schema selected. I can see all the �??FEATURE DATASET�?� (just the FEATURE DATASET name but not its content that BB created
(please note, BB didn�??t give any permission to AA to �??select�?�, �??view�?��?�any dataset)


We would like the result of TEST SDE, but not PROD

Both PROD and TEST sde have the same setup.
We are using ArcGIS 10.1, Oracle 11.2.0.3 64-bit

Please help.

thanks a lot : )
WL

Outcomes