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