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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
