You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ro...@apache.org on 2004/11/16 20:01:26 UTC
cvs commit: jakarta-jetspeed-2/src/schema security-schema.xml
rogerrut 2004/11/16 11:01:26
Modified: src/schema security-schema.xml
Log:
Single Sign On SSO Framework
The current version of SSO relies on the Jetspeed security model (storage of credentials/Principals) but for future release it can be decoupled from Jetspeed.
Portlets (IFrame, perl, PHP) will be enhanced (Preference setting) so that they can enable SSO functionality.
Revision Changes Path
1.7 +36 -2 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.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- security-schema.xml 8 Nov 2004 03:23:37 -0000 1.6
+++ security-schema.xml 16 Nov 2004 19:01:26 -0000 1.7
@@ -17,7 +17,41 @@
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_1.dtd">
<!-- Autogenerated by JDBCToXMLSchema! -->
<database>
-
+<!--
+ CREATING TABLES FOR SINGLE SIGN ON (SSO)
+ It has dependency on the Security tables PRINCIPAL and CREDENTIALS
+ -->
+
+ <!--
+ Create Site to Credentials association Table
+ -->
+
+ <table name="SSO_SITE_TO_CREDENTIALS">
+ <column name="SITE_ID" required="true" type="INTEGER"/>
+ <column name="PRINCIPAL_ID" required="true" type="INTEGER"/>
+ <column name="CREDENTIAL_ID" required="true" type="INTEGER"/>
+ <foreign-key foreignTable="SSO_SITE">
+ <reference foreign="SITE_ID" local="SITE_ID"/>
+ </foreign-key>
+ <foreign-key foreignTable="SECURITY_PRINCIPAL">
+ <reference foreign="PRINCIPAL_ID" local="PRINCIPAL_ID"/>
+ </foreign-key>
+ <foreign-key foreignTable="SECURITY_CREDENTIAL">
+ <reference foreign="CREDENTIAL_ID" local="CREDENTIAL_ID"/>
+ </foreign-key>
+ </table>
+
+ <!--
+ Create SiteTable
+ -->
+ <table name="SSO_SITE">
+ <column name="SITE_ID" primaryKey="true" required="true" type="INTEGER"/>
+ <column name="NAME" required="true" size="254" type="VARCHAR"/>
+ <column name="URL" required="true" size="254" type="VARCHAR"/>
+ <column name="ALLOW_USER_SET" default="0" type="BIT"/>
+ <column name="REQUIRES_CERTIFICATE" default="0" type="BIT"/>
+ </table>
+
<!--
Create Security User Role Table
-->
@@ -122,5 +156,5 @@
<column name="MODIFIED_DATE" required="true" type="TIMESTAMP"/>
</table>
-
+
</database>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org