portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rwat...@apache.org
Subject cvs commit: jakarta-jetspeed-2/src/sql/oracle populate-userinfo-for-default-psml.sql
Date Tue, 25 Jan 2005 00:49:34 GMT
rwatler     2005/01/24 16:49:34

  Modified:    src/sql  populate-userinfo-for-default-psml.sql
               src/sql/mssql populate-userinfo-for-default-psml.sql
               src/sql/mysql populate-userinfo-for-default-psml.sql
               src/sql/oracle populate-userinfo-for-default-psml.sql
  Log:
  add subsite configuration
  
  Revision  Changes    Path
  1.14      +69 -9     jakarta-jetspeed-2/src/sql/populate-userinfo-for-default-psml.sql
  
  Index: populate-userinfo-for-default-psml.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/src/sql/populate-userinfo-for-default-psml.sql,v
  retrieving revision 1.13
  retrieving revision 1.14
  diff -u -r1.13 -r1.14
  --- populate-userinfo-for-default-psml.sql	1 Dec 2004 20:19:38 -0000	1.13
  +++ populate-userinfo-for-default-psml.sql	25 Jan 2005 00:49:34 -0000	1.14
  @@ -36,19 +36,79 @@
   INSERT INTO SECURITY_USER_GROUP VALUES(5,13);
   INSERT INTO SECURITY_PERMISSION VALUES(1,'org.apache.jetspeed.security.FolderPermission','<<ALL
FILES>>','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
   INSERT INTO SECURITY_PERMISSION VALUES(2,'org.apache.jetspeed.security.FolderPermission','<<ALL
FILES>>','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(3,'org.apache.jetspeed.security.FolderPermission','/*','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(4,'org.apache.jetspeed.security.FolderPermission','/non-java/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(5,'org.apache.jetspeed.security.FolderPermission','/third-party/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(6,'org.apache.jetspeed.security.FolderPermission','/anotherdir/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(7,'org.apache.jetspeed.security.FolderPermission','/top-links/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(8,'org.apache.jetspeed.security.PagePermission','/default-page.psml','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(9,'org.apache.jetspeed.security.FolderPermission','/_user/user/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO PRINCIPAL_PERMISSION VALUES(3,9);
  +INSERT INTO SECURITY_PERMISSION VALUES(3,'org.apache.jetspeed.security.FolderPermission','/','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(4,'org.apache.jetspeed.security.FolderPermission','/*','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(5,'org.apache.jetspeed.security.FolderPermission','/non-java/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(6,'org.apache.jetspeed.security.FolderPermission','/third-party/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(7,'org.apache.jetspeed.security.FolderPermission','/Public','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(8,'org.apache.jetspeed.security.FolderPermission','/Public/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(9,'org.apache.jetspeed.security.FolderPermission','/anotherdir/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(10,'org.apache.jetspeed.security.FolderPermission','/top-links/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(11,'org.apache.jetspeed.security.PagePermission','/default-page.psml','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(12,'org.apache.jetspeed.security.PagePermission','/rss.psml','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(13,'org.apache.jetspeed.security.FolderPermission','/_user/user','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(14,'org.apache.jetspeed.security.FolderPermission','/_user/user/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(3,13);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(3,14);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(6,1);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(7,2);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,3);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,4);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,5);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,6);
  -INSERT INTO PRINCIPAL_PERMISSION VALUES(8,7);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,8);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,9);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,10);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,7);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(10,8);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,11);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,12);
  +
  +
  +INSERT INTO SECURITY_PRINCIPAL VALUES(50,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +INSERT INTO SECURITY_PRINCIPAL VALUES(51,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite2','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +INSERT INTO SECURITY_CREDENTIAL VALUES(50,50,'subsite',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2005-01-01
00:00:00.000','2005-01-01 00:00:00.000',null,null,null);
  +INSERT INTO SECURITY_CREDENTIAL VALUES(51,51,'subsite2',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2005-01-01
00:00:00.000','2005-01-01 00:00:00.000',null,null,null);
  +
  +INSERT INTO SECURITY_PRINCIPAL VALUES(52,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +INSERT INTO SECURITY_PRINCIPAL VALUES(53,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite2','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +
  +INSERT INTO SECURITY_USER_ROLE VALUES(50,52);
  +INSERT INTO SECURITY_USER_ROLE VALUES(50,53);
  +INSERT INTO SECURITY_USER_ROLE VALUES(51,52);
  +INSERT INTO SECURITY_USER_ROLE VALUES(51,53);
  +
  +insert into PROFILING_RULE values ('subsite-role-fallback-home',
  +     'org.apache.jetspeed.profiler.rules.impl.RoleFallbackProfilingRule',
  +     'A rule based on role fallback algorithm with specified subsite and home page');
  +insert into RULE_CRITERION values (50, 'subsite-role-fallback-home', 0, 'navigation', 'navigation',
'subsite-root', 2);
  +insert into RULE_CRITERION values (51, 'subsite-role-fallback-home', 1, 'role', 'role',
null, 2);
  +insert into RULE_CRITERION values (52, 'subsite-role-fallback-home', 2, 'path', 'path',
'subsite-default-page', 0);
  +
  +insert into PROFILING_RULE values ('subsite2-role-fallback-home', 
  +     'org.apache.jetspeed.profiler.rules.impl.RoleFallbackProfilingRule',
  +     'A rule based on role fallback algorithm with specified subsite and home page');
  +insert into RULE_CRITERION values (53, 'subsite2-role-fallback-home', 0, 'navigation',
'navigation', 'subsite-root', 2);
  +insert into RULE_CRITERION values (54, 'subsite2-role-fallback-home', 1, 'role', 'role',
null, 2);
  +insert into RULE_CRITERION values (55, 'subsite2-role-fallback-home', 2, 'path', 'path',
'subsite2-default-page', 0);
  +
  +insert into PRINCIPAL_RULE_ASSOC values ('subsite', 'page', 'subsite-role-fallback-home');
  +insert into PRINCIPAL_RULE_ASSOC values ('subsite2', 'page', 'subsite2-role-fallback-home');
  +
  +INSERT INTO SECURITY_PERMISSION VALUES(50,'org.apache.jetspeed.security.FolderPermission','/__subsite-root','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(51,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(52,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(53,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(54,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(55,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(50,52);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(50,53);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(51,54);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(51,55);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,50);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,51);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,50);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,51);
  
  
  
  1.8       +69 -9     jakarta-jetspeed-2/src/sql/mssql/populate-userinfo-for-default-psml.sql
  
  Index: populate-userinfo-for-default-psml.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/src/sql/mssql/populate-userinfo-for-default-psml.sql,v
  retrieving revision 1.7
  retrieving revision 1.8
  diff -u -r1.7 -r1.8
  --- populate-userinfo-for-default-psml.sql	3 Dec 2004 23:12:12 -0000	1.7
  +++ populate-userinfo-for-default-psml.sql	25 Jan 2005 00:49:34 -0000	1.8
  @@ -36,19 +36,79 @@
   INSERT INTO SECURITY_USER_GROUP VALUES(5,13);
   INSERT INTO SECURITY_PERMISSION VALUES(1,'org.apache.jetspeed.security.FolderPermission','<<ALL
FILES>>','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
   INSERT INTO SECURITY_PERMISSION VALUES(2,'org.apache.jetspeed.security.FolderPermission','<<ALL
FILES>>','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(3,'org.apache.jetspeed.security.FolderPermission','/*','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(4,'org.apache.jetspeed.security.FolderPermission','/non-java/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(5,'org.apache.jetspeed.security.FolderPermission','/third-party/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(6,'org.apache.jetspeed.security.FolderPermission','/anotherdir/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(7,'org.apache.jetspeed.security.FolderPermission','/top-links/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(8,'org.apache.jetspeed.security.PagePermission','/default-page.psml','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(9,'org.apache.jetspeed.security.FolderPermission','/_user/user/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO PRINCIPAL_PERMISSION VALUES(3,9);
  +INSERT INTO SECURITY_PERMISSION VALUES(3,'org.apache.jetspeed.security.FolderPermission','/','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(4,'org.apache.jetspeed.security.FolderPermission','/*','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(5,'org.apache.jetspeed.security.FolderPermission','/non-java/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(6,'org.apache.jetspeed.security.FolderPermission','/third-party/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(7,'org.apache.jetspeed.security.FolderPermission','/Public','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(8,'org.apache.jetspeed.security.FolderPermission','/Public/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(9,'org.apache.jetspeed.security.FolderPermission','/anotherdir/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(10,'org.apache.jetspeed.security.FolderPermission','/top-links/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(11,'org.apache.jetspeed.security.PagePermission','/default-page.psml','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(12,'org.apache.jetspeed.security.PagePermission','/rss.psml','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(13,'org.apache.jetspeed.security.FolderPermission','/_user/user','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(14,'org.apache.jetspeed.security.FolderPermission','/_user/user/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(3,13);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(3,14);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(6,1);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(7,2);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,3);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,4);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,5);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,6);
  -INSERT INTO PRINCIPAL_PERMISSION VALUES(8,7);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,8);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,9);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,10);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,7);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(10,8);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,11);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,12);
  +
  +
  +INSERT INTO SECURITY_PRINCIPAL VALUES(50,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +INSERT INTO SECURITY_PRINCIPAL VALUES(51,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite2','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +INSERT INTO SECURITY_CREDENTIAL VALUES(50,50,'subsite',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2005-01-01
00:00:00.000','2005-01-01 00:00:00.000',null,null,null);
  +INSERT INTO SECURITY_CREDENTIAL VALUES(51,51,'subsite2',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2005-01-01
00:00:00.000','2005-01-01 00:00:00.000',null,null,null);
  +
  +INSERT INTO SECURITY_PRINCIPAL VALUES(52,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +INSERT INTO SECURITY_PRINCIPAL VALUES(53,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite2','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +
  +INSERT INTO SECURITY_USER_ROLE VALUES(50,52);
  +INSERT INTO SECURITY_USER_ROLE VALUES(50,53);
  +INSERT INTO SECURITY_USER_ROLE VALUES(51,52);
  +INSERT INTO SECURITY_USER_ROLE VALUES(51,53);
  +
  +insert into PROFILING_RULE values ('subsite-role-fallback-home',
  +     'org.apache.jetspeed.profiler.rules.impl.RoleFallbackProfilingRule',
  +     'A rule based on role fallback algorithm with specified subsite and home page');
  +insert into RULE_CRITERION values (50, 'subsite-role-fallback-home', 0, 'navigation', 'navigation',
'subsite-root', 2);
  +insert into RULE_CRITERION values (51, 'subsite-role-fallback-home', 1, 'role', 'role',
null, 2);
  +insert into RULE_CRITERION values (52, 'subsite-role-fallback-home', 2, 'path', 'path',
'subsite-default-page', 0);
  +
  +insert into PROFILING_RULE values ('subsite2-role-fallback-home', 
  +     'org.apache.jetspeed.profiler.rules.impl.RoleFallbackProfilingRule',
  +     'A rule based on role fallback algorithm with specified subsite and home page');
  +insert into RULE_CRITERION values (53, 'subsite2-role-fallback-home', 0, 'navigation',
'navigation', 'subsite-root', 2);
  +insert into RULE_CRITERION values (54, 'subsite2-role-fallback-home', 1, 'role', 'role',
null, 2);
  +insert into RULE_CRITERION values (55, 'subsite2-role-fallback-home', 2, 'path', 'path',
'subsite2-default-page', 0);
  +
  +insert into PRINCIPAL_RULE_ASSOC values ('subsite', 'page', 'subsite-role-fallback-home');
  +insert into PRINCIPAL_RULE_ASSOC values ('subsite2', 'page', 'subsite2-role-fallback-home');
  +
  +INSERT INTO SECURITY_PERMISSION VALUES(50,'org.apache.jetspeed.security.FolderPermission','/__subsite-root','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(51,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(52,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(53,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(54,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(55,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(50,52);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(50,53);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(51,54);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(51,55);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,50);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,51);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,50);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,51);
  
  
  
  1.10      +69 -9     jakarta-jetspeed-2/src/sql/mysql/populate-userinfo-for-default-psml.sql
  
  Index: populate-userinfo-for-default-psml.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/src/sql/mysql/populate-userinfo-for-default-psml.sql,v
  retrieving revision 1.9
  retrieving revision 1.10
  diff -u -r1.9 -r1.10
  --- populate-userinfo-for-default-psml.sql	25 Nov 2004 02:25:58 -0000	1.9
  +++ populate-userinfo-for-default-psml.sql	25 Jan 2005 00:49:34 -0000	1.10
  @@ -36,19 +36,79 @@
   INSERT INTO SECURITY_USER_GROUP VALUES(5,13);
   INSERT INTO SECURITY_PERMISSION VALUES(1,'org.apache.jetspeed.security.FolderPermission','<<ALL
FILES>>','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
   INSERT INTO SECURITY_PERMISSION VALUES(2,'org.apache.jetspeed.security.FolderPermission','<<ALL
FILES>>','view','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(3,'org.apache.jetspeed.security.FolderPermission','/*','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(4,'org.apache.jetspeed.security.FolderPermission','/non-java/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(5,'org.apache.jetspeed.security.FolderPermission','/third-party/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(6,'org.apache.jetspeed.security.FolderPermission','/anotherdir/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(7,'org.apache.jetspeed.security.FolderPermission','/top-links/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(8,'org.apache.jetspeed.security.PagePermission','/default-page.psml','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO SECURITY_PERMISSION VALUES(9,'org.apache.jetspeed.security.FolderPermission','/_user/user/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  -INSERT INTO PRINCIPAL_PERMISSION VALUES(3,9);
  +INSERT INTO SECURITY_PERMISSION VALUES(3,'org.apache.jetspeed.security.FolderPermission','/','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(4,'org.apache.jetspeed.security.FolderPermission','/*','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(5,'org.apache.jetspeed.security.FolderPermission','/non-java/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(6,'org.apache.jetspeed.security.FolderPermission','/third-party/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(7,'org.apache.jetspeed.security.FolderPermission','/Public','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(8,'org.apache.jetspeed.security.FolderPermission','/Public/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(9,'org.apache.jetspeed.security.FolderPermission','/anotherdir/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(10,'org.apache.jetspeed.security.FolderPermission','/top-links/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(11,'org.apache.jetspeed.security.PagePermission','/default-page.psml','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(12,'org.apache.jetspeed.security.PagePermission','/rss.psml','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(13,'org.apache.jetspeed.security.FolderPermission','/_user/user','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(14,'org.apache.jetspeed.security.FolderPermission','/_user/user/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(3,13);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(3,14);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(6,1);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(7,2);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,3);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,4);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,5);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,6);
  -INSERT INTO PRINCIPAL_PERMISSION VALUES(8,7);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,8);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,9);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,10);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,7);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(10,8);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,11);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,12);
  +
  +
  +INSERT INTO SECURITY_PRINCIPAL VALUES(50,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +INSERT INTO SECURITY_PRINCIPAL VALUES(51,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite2','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +INSERT INTO SECURITY_CREDENTIAL VALUES(50,50,'subsite',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2005-01-01
00:00:00.000','2005-01-01 00:00:00.000',null,null,null);
  +INSERT INTO SECURITY_CREDENTIAL VALUES(51,51,'subsite2',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2005-01-01
00:00:00.000','2005-01-01 00:00:00.000',null,null,null);
  +
  +INSERT INTO SECURITY_PRINCIPAL VALUES(52,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +INSERT INTO SECURITY_PRINCIPAL VALUES(53,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite2','2005-01-01
00:00:00.000','2005-01-01 00:00:00.000');
  +
  +INSERT INTO SECURITY_USER_ROLE VALUES(50,52);
  +INSERT INTO SECURITY_USER_ROLE VALUES(50,53);
  +INSERT INTO SECURITY_USER_ROLE VALUES(51,52);
  +INSERT INTO SECURITY_USER_ROLE VALUES(51,53);
  +
  +insert into PROFILING_RULE values ('subsite-role-fallback-home',
  +     'org.apache.jetspeed.profiler.rules.impl.RoleFallbackProfilingRule',
  +     'A rule based on role fallback algorithm with specified subsite and home page');
  +insert into RULE_CRITERION values (50, 'subsite-role-fallback-home', 0, 'navigation', 'navigation',
'subsite-root', 2);
  +insert into RULE_CRITERION values (51, 'subsite-role-fallback-home', 1, 'role', 'role',
null, 2);
  +insert into RULE_CRITERION values (52, 'subsite-role-fallback-home', 2, 'path', 'path',
'subsite-default-page', 0);
  +
  +insert into PROFILING_RULE values ('subsite2-role-fallback-home', 
  +     'org.apache.jetspeed.profiler.rules.impl.RoleFallbackProfilingRule',
  +     'A rule based on role fallback algorithm with specified subsite and home page');
  +insert into RULE_CRITERION values (53, 'subsite2-role-fallback-home', 0, 'navigation',
'navigation', 'subsite-root', 2);
  +insert into RULE_CRITERION values (54, 'subsite2-role-fallback-home', 1, 'role', 'role',
null, 2);
  +insert into RULE_CRITERION values (55, 'subsite2-role-fallback-home', 2, 'path', 'path',
'subsite2-default-page', 0);
  +
  +insert into PRINCIPAL_RULE_ASSOC values ('subsite', 'page', 'subsite-role-fallback-home');
  +insert into PRINCIPAL_RULE_ASSOC values ('subsite2', 'page', 'subsite2-role-fallback-home');
  +
  +INSERT INTO SECURITY_PERMISSION VALUES(50,'org.apache.jetspeed.security.FolderPermission','/__subsite-root','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(51,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(52,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(53,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(54,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(55,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(50,52);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(50,53);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(51,54);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(51,55);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,50);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,51);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,50);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,51);
  
  
  
  1.11      +69 -9     jakarta-jetspeed-2/src/sql/oracle/populate-userinfo-for-default-psml.sql
  
  Index: populate-userinfo-for-default-psml.sql
  ===================================================================
  RCS file: /home/cvs/jakarta-jetspeed-2/src/sql/oracle/populate-userinfo-for-default-psml.sql,v
  retrieving revision 1.10
  retrieving revision 1.11
  diff -u -r1.10 -r1.11
  --- populate-userinfo-for-default-psml.sql	25 Nov 2004 02:25:58 -0000	1.10
  +++ populate-userinfo-for-default-psml.sql	25 Jan 2005 00:49:34 -0000	1.11
  @@ -36,19 +36,79 @@
   INSERT INTO SECURITY_USER_GROUP VALUES(5,13);
   INSERT INTO SECURITY_PERMISSION VALUES(1,'org.apache.jetspeed.security.FolderPermission','<<ALL
FILES>>','view, edit',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'));
   INSERT INTO SECURITY_PERMISSION VALUES(2,'org.apache.jetspeed.security.FolderPermission','<<ALL
FILES>>','view',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'));
  -INSERT INTO SECURITY_PERMISSION VALUES(3,'org.apache.jetspeed.security.FolderPermission','/*','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  -INSERT INTO SECURITY_PERMISSION VALUES(4,'org.apache.jetspeed.security.FolderPermission','/non-java/-','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  -INSERT INTO SECURITY_PERMISSION VALUES(5,'org.apache.jetspeed.security.FolderPermission','/third-party/-','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  -INSERT INTO SECURITY_PERMISSION VALUES(6,'org.apache.jetspeed.security.FolderPermission','/anotherdir/-','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  -INSERT INTO SECURITY_PERMISSION VALUES(7,'org.apache.jetspeed.security.FolderPermission','/top-links/-','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  -INSERT INTO SECURITY_PERMISSION VALUES(8,'org.apache.jetspeed.security.PagePermission','/default-page.psml','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  -INSERT INTO SECURITY_PERMISSION VALUES(9,'org.apache.jetspeed.security.FolderPermission','/_user/user/-','view,
edit',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD
HH24:MI:SS'));
  -INSERT INTO PRINCIPAL_PERMISSION VALUES(3,9);
  +INSERT INTO SECURITY_PERMISSION VALUES(3,'org.apache.jetspeed.security.FolderPermission','/','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  +INSERT INTO SECURITY_PERMISSION VALUES(4,'org.apache.jetspeed.security.FolderPermission','/*','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  +INSERT INTO SECURITY_PERMISSION VALUES(5,'org.apache.jetspeed.security.FolderPermission','/non-java/-','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  +INSERT INTO SECURITY_PERMISSION VALUES(6,'org.apache.jetspeed.security.FolderPermission','/third-party/-','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  +INSERT INTO SECURITY_PERMISSION VALUES(7,'org.apache.jetspeed.security.FolderPermission','/Public','view,
edit',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD
HH24:MI:SS'));
  +INSERT INTO SECURITY_PERMISSION VALUES(8,'org.apache.jetspeed.security.FolderPermission','/Public/-','view,
edit',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD
HH24:MI:SS'));
  +INSERT INTO SECURITY_PERMISSION VALUES(9,'org.apache.jetspeed.security.FolderPermission','/anotherdir/-','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  +INSERT INTO SECURITY_PERMISSION VALUES(10,'org.apache.jetspeed.security.FolderPermission','/top-links/-','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  +INSERT INTO SECURITY_PERMISSION VALUES(11,'org.apache.jetspeed.security.PagePermission','/default-page.psml','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  +INSERT INTO SECURITY_PERMISSION VALUES(12,'org.apache.jetspeed.security.PagePermission','/rss.psml','view',to_date('2004-05-22
16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'));
  +INSERT INTO SECURITY_PERMISSION VALUES(13,'org.apache.jetspeed.security.FolderPermission','/_user/user','view,
edit',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD
HH24:MI:SS'));
  +INSERT INTO SECURITY_PERMISSION VALUES(14,'org.apache.jetspeed.security.FolderPermission','/_user/user/-','view,
edit',to_date('2004-05-22 16:27:12','YYYY-MM-DD HH24:MI:SS'),to_date('2004-05-22 16:27:12','YYYY-MM-DD
HH24:MI:SS'));
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(3,13);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(3,14);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(6,1);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(7,2);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,3);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,4);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,5);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(8,6);
  -INSERT INTO PRINCIPAL_PERMISSION VALUES(8,7);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,8);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,9);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(8,10);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,7);
   INSERT INTO PRINCIPAL_PERMISSION VALUES(10,8);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,11);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(10,12);
  +
  +
  +INSERT INTO SECURITY_PRINCIPAL VALUES(50,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite',to_date('2005-01-01
00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'));
  +INSERT INTO SECURITY_PRINCIPAL VALUES(51,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite2',to_date('2005-01-01
00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'));
  +INSERT INTO SECURITY_CREDENTIAL VALUES(50,50,'subsite',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,to_date('2005-01-01
00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,null,null);
  +INSERT INTO SECURITY_CREDENTIAL VALUES(51,51,'subsite2',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,to_date('2005-01-01
00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'),null,null,null);
  +
  +INSERT INTO SECURITY_PRINCIPAL VALUES(52,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite',to_date('2005-01-01
00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'));
  +INSERT INTO SECURITY_PRINCIPAL VALUES(53,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/subsite2',to_date('2005-01-01
00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-01-01 00:00:00','YYYY-MM-DD HH24:MI:SS'));
  +
  +INSERT INTO SECURITY_USER_ROLE VALUES(50,52);
  +INSERT INTO SECURITY_USER_ROLE VALUES(50,53);
  +INSERT INTO SECURITY_USER_ROLE VALUES(51,52);
  +INSERT INTO SECURITY_USER_ROLE VALUES(51,53);
  +
  +insert into PROFILING_RULE values ('subsite-role-fallback-home',
  +     'org.apache.jetspeed.profiler.rules.impl.RoleFallbackProfilingRule',
  +     'A rule based on role fallback algorithm with specified subsite and home page');
  +insert into RULE_CRITERION values (50, 'subsite-role-fallback-home', 0, 'navigation', 'navigation',
'subsite-root', 2);
  +insert into RULE_CRITERION values (51, 'subsite-role-fallback-home', 1, 'role', 'role',
null, 2);
  +insert into RULE_CRITERION values (52, 'subsite-role-fallback-home', 2, 'path', 'path',
'subsite-default-page', 0);
  +
  +insert into PROFILING_RULE values ('subsite2-role-fallback-home', 
  +     'org.apache.jetspeed.profiler.rules.impl.RoleFallbackProfilingRule',
  +     'A rule based on role fallback algorithm with specified subsite and home page');
  +insert into RULE_CRITERION values (53, 'subsite2-role-fallback-home', 0, 'navigation',
'navigation', 'subsite-root', 2);
  +insert into RULE_CRITERION values (54, 'subsite2-role-fallback-home', 1, 'role', 'role',
null, 2);
  +insert into RULE_CRITERION values (55, 'subsite2-role-fallback-home', 2, 'path', 'path',
'subsite2-default-page', 0);
  +
  +insert into PRINCIPAL_RULE_ASSOC values ('subsite', 'page', 'subsite-role-fallback-home');
  +insert into PRINCIPAL_RULE_ASSOC values ('subsite2', 'page', 'subsite2-role-fallback-home');
  +
  +INSERT INTO SECURITY_PERMISSION VALUES(50,'org.apache.jetspeed.security.FolderPermission','/__subsite-root','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(51,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/-','view','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(52,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(53,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(54,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO SECURITY_PERMISSION VALUES(55,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite2/-','view,
edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(50,52);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(50,53);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(51,54);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(51,55);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,50);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(52,51);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,50);
  +INSERT INTO PRINCIPAL_PERMISSION VALUES(53,51);
  
  
  

---------------------------------------------------------------------
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