rogerrut 2004/11/30 10:14:32
Modified: src/schema security-schema.xml
Log:
Updated SSO Framework. The relationship between site/principal and remote
principal is defined as following:
--> each site can have multiple principals (Jetspeed user principal)
--> each principals has a remote principal and an associated credential
--> A jetspeed user can only have one remote principal/credential per site
--> A site can be an url (IFrame) or an application instance (PHP)
Revision Changes Path
1.10 +14 -14 jakarta-jetspeed-2/src/schema/security-schema.xml
Index: security-schema.xml
===================================================================
RCS file: /home/cvs/jakarta-jetspeed-2/src/schema/security-schema.xml,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- security-schema.xml 25 Nov 2004 02:25:57 -0000 1.9
+++ security-schema.xml 30 Nov 2004 18:14:31 -0000 1.10
@@ -21,34 +21,34 @@
CREATING TABLES FOR SINGLE SIGN ON (SSO)
It has dependency on the Security tables PRINCIPAL and CREDENTIALS
-->
-
+
<!--
- Create Site to Credentials association Table
+ Create Site to Principals association Table
-->
- <table name="SSO_SITE_TO_CREDENTIALS">
+ <table name="SSO_SITE_TO_PRINCIPALS">
<column name="SITE_ID" primaryKey="true" required="true"
type="INTEGER"/>
- <column name="CREDENTIAL_ID" primaryKey="true" required="true"
type="INTEGER"/>
- <foreign-key foreignTable="SSO_SITE">
+ <column name="PRINCIPAL_ID" primaryKey="true" required="true"
type="INTEGER"/>
+ <foreign-key foreignTable="SSO_SITE">
<reference foreign="SITE_ID" local="SITE_ID"/>
</foreign-key>
- <foreign-key foreignTable="SECURITY_CREDENTIAL">
- <reference foreign="CREDENTIAL_ID" local="CREDENTIAL_ID"/>
+ <foreign-key foreignTable="SECURITY_PRINCIPAL">
+ <reference foreign="PRINCIPAL_ID" local="PRINCIPAL_ID"/>
</foreign-key>
</table>
<!--
- Create Site to Principals association Table
+ Create Principals to Remote Principals association Table
-->
- <table name="SSO_SITE_TO_PRINCIPALS">
- <column name="SITE_ID" primaryKey="true" required="true"
type="INTEGER"/>
- <column name="PRINCIPAL_ID" primaryKey="true" required="true"
type="INTEGER"/>
- <foreign-key foreignTable="SSO_SITE">
- <reference foreign="SITE_ID" local="SITE_ID"/>
+ <table name="SSO_PRINCIPAL_TO_REMOTE_PRINCIPAL">
+ <column name="PRINCIPAL_ID" primaryKey="true" required="true"
type="INTEGER"/>
+ <column name="REMOTE_PRINCIPAL_ID" primaryKey="true" required="true"
type="INTEGER"/>
+ <foreign-key foreignTable="SECURITY_PRINCIPAL">
+ <reference foreign="PRINCIPAL_ID" local="PRINCIPAL_ID"/>
</foreign-key>
<foreign-key foreignTable="SECURITY_PRINCIPAL">
- <reference foreign="PRINCIPAL_ID" local="PRINCIPAL_ID"/>
+ <reference foreign="PRINCIPAL_ID" local="REMOTE_PRINCIPAL_ID"/>
</foreign-key>
</table>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
