2 Replies Latest reply on Feb 28, 2013 5:14 AM by Vite DBA

    How to add workspace schema?

    Cheney Shue
      In applications, it can only select tables from one workspace schema. Can I add more schema?
        • 1. Re: How to add workspace schema?
          jariola
          Hi,

          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.

          Regards,
          Jari
          -----
          My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
          Twitter: http://www.twitter.com/jariolai
          • 2. Re: How to add workspace schema?
            Vite DBA
            Hi,

            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.

            Regards
            Andre