> -----Ursprungliche Nachricht-----
> Von: Scott Eade [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 2. Oktober 2002 14:17
> An: turbine-user
> Betreff: Re: joins to turbine tables
>
>
> > From: "Marc Lustig" <[EMAIL PROTECTED]>
> Mail list archaeologist at large ;-)
> >
> > Hi Scott, and everybody,
> > more than a year ago you wrote the message below.
> > (There has been no reply to your message.)
> > What I need to do is building a security framework for
> customers to inherit
> > their rights (roles,permissions) to sub-customers. I have
> app-tables that
> > hold reseller-specific security data. This is supposed to be kind of
> > extension of the basic turbine security framework. (I can't explain the
> > whole thing, it's rather complex.)
> > Anyway, I need to reference various turbine security tables.
> > So I wonder if you have figured out a solution for the problem that you
> > outlined in your message.
> > I was thinking about aliasing all the tables (like for
> extending the user)
> > but I'd like to make sure there isn't any better/easer solution before.
> >
> > TIA.
> > Marc
> The solution involved using an alias as described in the extend-user-howto
> document - i.e. the turbine 2.1 solution. It should be achievable under
> turbine 2.2bx, but it may require the use of the fulcrum security service
> rather than the one included in turbine itself (and I keep pointing people
> to Henning's proposed security service even though I haven't yet had the
> chance to try it myself).
After sorting things out a bit I decided to stay with the old security
service implementation, as using the fulcrum-based sercurity service is
still in an experimental state. I'd like to try this out, but I really don't
have the time for this.
So if the following won't work, I will forget about the foreign-key and
handle the links manually in the code:
<table name="BASE_ROLE" javaName="BaseRole" alias="TurbineRole">
<column name="ROLE_ID" primaryKey="true" required="true"
type="INTEGER"/>
</table>
<table name="RESELLER_ROLE">
<column name="RESELLER_ROLE_ID" required="true" primaryKey="true"
type="INTEGER"/>
<column name="NAME" type="VARCHAR" size="255"/>
<column name="USER_ID" type="INTEGER"/>
<column name="ROLE_ID" type="INTEGER"/>
<foreign-key foreignTable="AUDIOTEX_USER">
<reference local="USER_ID" foreign="USER_ID"/>
</foreign-key>
<foreign-key foreignTable="BASE_ROLE">
<reference local="ROLE_ID" foreign="ROLE_ID"/>
</foreign-key>
</table>
Marc
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
