taylor 2002/06/18 22:20:37
Modified: src/sql/external Tag: security_14 populate-db2.sql
populate-mysql.sql populate-oracle.sql
populate-postgres.sql populate-sybase.sql
webapp/WEB-INF/db Tag: security_14 jetspeed.script
Log:
Added 'guest' role to default hypersonic db and db population scripts
Revision Changes Path
No revision
No revision
1.6.2.2 +3 -0 jakarta-jetspeed/src/sql/external/populate-db2.sql
Index: populate-db2.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-db2.sql,v
retrieving revision 1.6.2.1
retrieving revision 1.6.2.2
diff -u -r1.6.2.1 -r1.6.2.2
--- populate-db2.sql 18 Jun 2002 06:49:35 -0000 1.6.2.1
+++ populate-db2.sql 19 Jun 2002 05:20:37 -0000 1.6.2.2
@@ -8,6 +8,7 @@
INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
+INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
INSERT INTO TURBINE_USER
VALUES(1,'admin','jetspeed','Raphael','Admin','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
@@ -26,6 +27,8 @@
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7);
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,1);
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
1.8.2.2 +3 -0 jakarta-jetspeed/src/sql/external/populate-mysql.sql
Index: populate-mysql.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-mysql.sql,v
retrieving revision 1.8.2.1
retrieving revision 1.8.2.2
diff -u -r1.8.2.1 -r1.8.2.2
--- populate-mysql.sql 18 Jun 2002 06:49:35 -0000 1.8.2.1
+++ populate-mysql.sql 19 Jun 2002 05:20:37 -0000 1.8.2.2
@@ -8,6 +8,7 @@
INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
+INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
INSERT INTO TURBINE_USER
VALUES(1,'admin','jetspeed','Raphael','Admin','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
@@ -26,6 +27,8 @@
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7);
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,1);
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
1.4.2.2 +3 -0 jakarta-jetspeed/src/sql/external/populate-oracle.sql
Index: populate-oracle.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-oracle.sql,v
retrieving revision 1.4.2.1
retrieving revision 1.4.2.2
diff -u -r1.4.2.1 -r1.4.2.2
--- populate-oracle.sql 18 Jun 2002 06:49:35 -0000 1.4.2.1
+++ populate-oracle.sql 19 Jun 2002 05:20:37 -0000 1.4.2.2
@@ -8,6 +8,7 @@
INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
+INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
INSERT INTO TURBINE_USER
VALUES(0,'turbine','turbine','David','Turbine','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007478');
@@ -26,6 +27,8 @@
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7);
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,1);
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(0,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
1.7.2.2 +3 -0 jakarta-jetspeed/src/sql/external/populate-postgres.sql
Index: populate-postgres.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-postgres.sql,v
retrieving revision 1.7.2.1
retrieving revision 1.7.2.2
diff -u -r1.7.2.1 -r1.7.2.2
--- populate-postgres.sql 18 Jun 2002 06:49:35 -0000 1.7.2.1
+++ populate-postgres.sql 19 Jun 2002 05:20:37 -0000 1.7.2.2
@@ -8,6 +8,7 @@
INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
+INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
INSERT INTO TURBINE_USER
VALUES(1,'admin','jetspeed','Raphael','Admin','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'F',NULL);
@@ -26,6 +27,8 @@
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7);
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,1);
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
1.6.2.2 +3 -0 jakarta-jetspeed/src/sql/external/populate-sybase.sql
Index: populate-sybase.sql
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/src/sql/external/populate-sybase.sql,v
retrieving revision 1.6.2.1
retrieving revision 1.6.2.2
diff -u -r1.6.2.1 -r1.6.2.2
--- populate-sybase.sql 18 Jun 2002 06:49:35 -0000 1.6.2.1
+++ populate-sybase.sql 19 Jun 2002 05:20:37 -0000 1.6.2.2
@@ -8,6 +8,7 @@
INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
+INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL);
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
INSERT INTO TURBINE_USER
VALUES(1,'admin','jetspeed','Raphael','Admin','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,NULL,'F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
@@ -26,6 +27,8 @@
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7);
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,1);
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(2,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
No revision
No revision
1.13.2.10 +3 -0 jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script
Index: jetspeed.script
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script,v
retrieving revision 1.13.2.9
retrieving revision 1.13.2.10
diff -u -r1.13.2.9 -r1.13.2.10
--- jetspeed.script 19 Jun 2002 05:14:12 -0000 1.13.2.9
+++ jetspeed.script 19 Jun 2002 05:20:37 -0000 1.13.2.10
@@ -97,6 +97,7 @@
INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL)
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL)
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL)
+INSERT INTO TURBINE_ROLE VALUES(3,'guest',NULL)
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL)
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL)
INSERT INTO TURBINE_USER
VALUES(0,'turbine','turbine','Tommy','Turbine','[EMAIL PROTECTED]','CONFIRMED',NULL,NULL,'2002-06-04
16:05:25.712','F','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000577080000000700000003740008756e69747465737474000074000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b020000787000000076740007555345525f49447400013078')
@@ -115,6 +116,8 @@
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6)
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7)
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,1)
+INSERT INTO TURBINE_ROLE_PERMISSION VALUES(3,6)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(0,1,1)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1)
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2)
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
