You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Phillip Rhodes <rh...@telerama.com> on 2002/11/13 05:48:30 UTC

share same security tables as TDK 2.1?

I am deploying jetspeed for my new project "jsurvey" that is based upon 
turbine (TDK 2.1)

Are the security tables compatible between jetspeed and TDK 2.1?
For example, can I use same user, role, group, user_group_role tables 
between the applications?


Thanks!


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: share same security tables as TDK 2.1?

Posted by Phillip Rhodes <rh...@telerama.com>.
Extra columns won't hurt!  As long as they are there. If I use the Jetspeed 
table definitions, my TDK 2.1 apps will be fine.



At 09:13 PM 11/12/2002 -0800, you wrote:
>Almost but not quite.
>We've added 2 columns to the TURBINE_USER table, PASSWORD_CHANGED and
>DISABLED:
>
>CREATE TABLE TURBINE_USER
>(
>     USER_ID integer IDENTITY,
>     LOGIN_NAME VARCHAR (32),
>     PASSWORD_VALUE VARCHAR (32),
>     FIRST_NAME VARCHAR (99),
>     LAST_NAME VARCHAR (99),
>     EMAIL VARCHAR (99),
>     CONFIRM_VALUE VARCHAR (99),
>     MODIFIED timestamp,
>     CREATED timestamp,
>     LAST_LOGIN timestamp,
>     DISABLED VARCHAR (1),
>     OBJECTDATA BINARY,
>     PASSWORD_CHANGED timestamp,
>     PRIMARY KEY(USER_ID),
>     UNIQUE (LOGIN_NAME)
>);
>
> > -----Original Message-----
> > From: Phillip Rhodes [mailto:rhodespc@telerama.com]
> > Sent: Tuesday, November 12, 2002 8:49 PM
> > To: jetspeed-user@jakarta.apache.org
> > Subject: share same security tables as TDK 2.1?
> >
> >
> > I am deploying jetspeed for my new project "jsurvey" that is based upon
> > turbine (TDK 2.1)
> >
> > Are the security tables compatible between jetspeed and TDK 2.1?
> > For example, can I use same user, role, group, user_group_role tables
> > between the applications?
> >
> >
> > Thanks!
> >
> >
> > --
> > To unsubscribe, e-mail:
> > <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
>
>
>
>--
>To unsubscribe, 
>e-mail:   <ma...@jakarta.apache.org>
>For additional commands, e-mail: 
><ma...@jakarta.apache.org>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>


RE: share same security tables as TDK 2.1?

Posted by David Sean Taylor <da...@bluesunrise.com>.
Almost but not quite.
We've added 2 columns to the TURBINE_USER table, PASSWORD_CHANGED and
DISABLED:

CREATE TABLE TURBINE_USER
(
    USER_ID integer IDENTITY,
    LOGIN_NAME VARCHAR (32),
    PASSWORD_VALUE VARCHAR (32),
    FIRST_NAME VARCHAR (99),
    LAST_NAME VARCHAR (99),
    EMAIL VARCHAR (99),
    CONFIRM_VALUE VARCHAR (99),
    MODIFIED timestamp,
    CREATED timestamp,
    LAST_LOGIN timestamp,
    DISABLED VARCHAR (1),
    OBJECTDATA BINARY,
    PASSWORD_CHANGED timestamp,
    PRIMARY KEY(USER_ID),
    UNIQUE (LOGIN_NAME)
);

> -----Original Message-----
> From: Phillip Rhodes [mailto:rhodespc@telerama.com]
> Sent: Tuesday, November 12, 2002 8:49 PM
> To: jetspeed-user@jakarta.apache.org
> Subject: share same security tables as TDK 2.1?
>
>
> I am deploying jetspeed for my new project "jsurvey" that is based upon
> turbine (TDK 2.1)
>
> Are the security tables compatible between jetspeed and TDK 2.1?
> For example, can I use same user, role, group, user_group_role tables
> between the applications?
>
>
> Thanks!
>
>
> --
> To unsubscribe, e-mail:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>