portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From roger...@apache.org
Subject cvs commit: jakarta-jetspeed-2/src/schema security-schema.xml
Date Tue, 16 Nov 2004 19:01:26 GMT
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


Mime
View raw message