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