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, 30 Nov 2004 18:14:32 GMT
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: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


Mime
View raw message