This content has been marked as final. Show 2 replies
Application can have only one parsing schema.
If one application need query tables from multiple schema, you need grant select privilege from other schemas to your application parsing schema.
My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
A workspace can have multiple schemas, more can be assigned through the Apex Administration App, but only one schema can act as the parsing schema. This means that objects in schemas other than the parsing schema will need grants to the parsing schema to execute correctly.