taylor 2004/11/18 19:08:28
Modified: src/sql/mysql populate-userinfo-for-default-psml.sql
src/sql/mssql populate-userinfo-for-default-psml.sql
src/sql populate-userinfo-for-default-psml.sql
src/sql/oracle populate-userinfo-for-default-psml.sql
Log:
scripts for JAAS permission checks policy
Revision Changes Path
1.8 +20 -0
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.7
retrieving revision 1.8
diff -u -r1.7 -r1.8
--- populate-userinfo-for-default-psml.sql 8 Nov 2004 03:23:37 -0000
1.7
+++ populate-userinfo-for-default-psml.sql 19 Nov 2004 03:08:28 -0000
1.8
@@ -33,3 +33,23 @@
INSERT INTO SECURITY_USER_ROLE VALUES(3,8);
INSERT INTO SECURITY_USER_ROLE VALUES(9,10);
INSERT INTO SECURITY_USER_ROLE VALUES(5,7);
+INSERT INTO SECURITY_USER_GROUP VALUES(3,11);
+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 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(10,8);
1.5 +20 -0
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.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- populate-userinfo-for-default-psml.sql 8 Nov 2004 03:23:36 -0000
1.4
+++ populate-userinfo-for-default-psml.sql 19 Nov 2004 03:08:28 -0000
1.5
@@ -33,3 +33,23 @@
INSERT INTO SECURITY_USER_ROLE VALUES(3,8);
INSERT INTO SECURITY_USER_ROLE VALUES(9,10);
INSERT INTO SECURITY_USER_ROLE VALUES(5,7);
+INSERT INTO SECURITY_USER_GROUP VALUES(3,11);
+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 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(10,8);
1.11 +20 -0
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.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- populate-userinfo-for-default-psml.sql 8 Nov 2004 03:23:37 -0000
1.10
+++ populate-userinfo-for-default-psml.sql 19 Nov 2004 03:08:28 -0000
1.11
@@ -33,3 +33,23 @@
INSERT INTO SECURITY_USER_ROLE VALUES(3,8);
INSERT INTO SECURITY_USER_ROLE VALUES(9,10);
INSERT INTO SECURITY_USER_ROLE VALUES(5,7);
+INSERT INTO SECURITY_USER_GROUP VALUES(3,11);
+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 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(10,8);
1.9 +20 -0
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.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- populate-userinfo-for-default-psml.sql 8 Nov 2004 03:23:37 -0000
1.8
+++ populate-userinfo-for-default-psml.sql 19 Nov 2004 03:08:28 -0000
1.9
@@ -33,3 +33,23 @@
INSERT INTO SECURITY_USER_ROLE VALUES(3,8);
INSERT INTO SECURITY_USER_ROLE VALUES(9,10);
INSERT INTO SECURITY_USER_ROLE VALUES(5,7);
+INSERT INTO SECURITY_USER_GROUP VALUES(3,11);
+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 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(10,8);
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
