cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Kienenberger" <mkien...@gmail.com>
Subject Re: Creating Oracle constraints across schemas
Date Thu, 20 Apr 2006 17:00:39 GMT
On 4/20/06, Chris Poulsen <mailinglist@nesluop.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?

Mime
View raw message