Re: Creating Oracle constraints across schemas

From: Mike Kienenberger (mkienen..mail.com)
Date: Thu Apr 20 2006 - 13:00:39 EDT

  • Next message: Andrus Adamchik: "Re: Creating Oracle constraints across schemas"

    On 4/20/06, Chris Poulsen <mailinglis..esluop.dk> wrote:
    > Cross schema constraints are available in oracle, however you need to
    > allow access to the object being referenced.
    >
    > Something like:
    > as user core_work_mgmt:
    > grant references on statusable_work to eng_work_mgmt
    >
    > before creating the constraint

    Interesting. That makes sense.
    I'll run it by our dev team and see if they want to do it.

    Thanks.
    It's still unclear what Cayenne's behavior should be, though.
    Maybe a "Should generate cross-schema constraints" preference item or
    method parameter?

    This archive was generated by hypermail 2.0.0 : Thu Apr 20 2006 - 13:01:14 EDT