portals-jetspeed-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "$aurabh Vig" <saurabh...@gmail.com>
Subject Re: User Management in jetSpeed 2 with Oracle
Date Tue, 06 Nov 2007 01:22:30 GMT
Hi David,

Thanx for the reply.
Actually I have been looking for any sorts of Jetspeed DB Schema
explanations but was not able to find anything online.
Is something like that available?

Thanks & Regards,
Saurabh

On Nov 6, 2007 12:25 AM, David Sean Taylor <david@bluesunrise.com> wrote:
>
>
> On Nov 4, 2007, at 11:42 PM, $aurabh Vig wrote:
>
> > Hi,
> >
> > I am new user of Jetspeed 2. I have installed Jetspeed2.1.2 with
> > oracleas DB.
> > I need to synchronize the users, roles and groups for Jetspeed portal
> > to act as the users on my portlets also.
> >
> > I am trying to figure out where is the user information stored for
> > users created in jetspeed.
> > The DB for my portlets need to refer to the user tables of Jetspeed
> > and link to them as foriegn key relation.
> >
> > Any help on this would be really appreciated.
> >
> >
> The users are stored in the SECURITY_PRINCIPAL table
> Unfortunately the schema is wrong, IMO
> I plan to fix this in version 2.2 to make integration at the SQL easier.
> The FULL_PATH column contains the username. Say you have a user "mary"
> The FULL_PATH column contains "/user/mary" so you will need to join
> with the constant "/user/"
> Additional user information (user attributes) is stored in the two
> preferences tables: PREFS_NODE and PREFS_PROPERTY_VALUE
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org


Mime
View raw message