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 $aurabh Vig <sa...@gmail.com> on 2007/11/05 08:42:05 UTC
User Management in jetSpeed 2 with Oracle
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.
Best Regards,
Saurabh Vig
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: User Management in jetSpeed 2 with Oracle
Posted by $aurabh Vig <sa...@gmail.com>.
Thanx David.
Regards,
Saurabh
On Nov 6, 2007 11:26 AM, David Sean Taylor <da...@bluesunrise.com> wrote:
>
> On Nov 5, 2007, at 5:22 PM, $aurabh Vig wrote:
>
> > 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?
> >
> Not much
>
> http://people.apache.org/~taylor/database/jetspeed-tables.html
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: User Management in jetSpeed 2 with Oracle
Posted by David Sean Taylor <da...@bluesunrise.com>.
On Nov 5, 2007, at 5:22 PM, $aurabh Vig wrote:
> 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?
>
Not much
http://people.apache.org/~taylor/database/jetspeed-tables.html
Re: User Management in jetSpeed 2 with Oracle
Posted by $aurabh Vig <sa...@gmail.com>.
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 <da...@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
Re: User Management in jetSpeed 2 with Oracle
Posted by David Sean Taylor <da...@bluesunrise.com>.
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