2 Replies Latest reply: Feb 27, 2013 11:14 PM by Vite DBA RSS

    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