taylor 2004/09/19 23:10:37
Modified: src/sql/mysql populate-userinfo-for-default-psml.sql
src/sql populate-userinfo-for-default-psml.sql
Log:
update scripts with new roles, groups
NOTE: i still need to update the scripts for Oracle
CVS: ----------------------------------------------------------------------
CVS: PR:
CVS: If this change addresses a PR in the problem report tracking
CVS: database, then enter the PR number(s) here.
CVS: Obtained from:
CVS: If this change has been taken from another system, such as NCSA,
CVS: then name the system in this line, otherwise delete it.
CVS: Submitted by:
CVS: If this code has been contributed to Apache by someone else; i.e.,
CVS: they sent us a patch or a new module, then include their name/email
CVS: address here. If this is your work then delete this line.
CVS: Reviewed by:
CVS: If we are doing pre-commit code reviews and someone else has
CVS: reviewed your changes, include their name(s) here.
CVS: If you have not had it reviewed then delete this line.
Revision Changes Path
1.2 +7 -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.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- populate-userinfo-for-default-psml.sql 24 May 2004 17:54:09 -0000 1.1
+++ populate-userinfo-for-default-psml.sql 20 Sep 2004 06:10:37 -0000 1.2
@@ -14,14 +14,21 @@
INSERT INTO SECURITY_PRINCIPAL
VALUES(6,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl','/role/admin','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_PRINCIPAL
VALUES(7,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl','/role/manager','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_PRINCIPAL
VALUES(8,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl','/role/user','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL
VALUES(9,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl','/user/guest','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL
VALUES(10,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl','/role/guest','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL
VALUES(11,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/accounting','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL
VALUES(12,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/marketing','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL
VALUES(13,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/engineering','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_CREDENTIAL VALUES(1,1,'admin',0,null,'2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'manager',0,null,'2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,null,'2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_CREDENTIAL VALUES(4,4,'tomcat',0,null,'2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_CREDENTIAL VALUES(5,5,'jetspeed',0,null,'2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_CREDENTIAL VALUES(9,9,'guest',0,null,'2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_USER_ROLE VALUES(1,6);
INSERT INTO SECURITY_USER_ROLE VALUES(1,7);
INSERT INTO SECURITY_USER_ROLE VALUES(1,8);
INSERT INTO SECURITY_USER_ROLE VALUES(2,7);
INSERT INTO SECURITY_USER_ROLE VALUES(2,8);
INSERT INTO SECURITY_USER_ROLE VALUES(3,8);
+INSERT INTO SECURITY_USER_ROLE VALUES(9,10);
1.4 +3 -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.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- populate-userinfo-for-default-psml.sql 20 Jul 2004 13:58:58 -0000 1.3
+++ populate-userinfo-for-default-psml.sql 20 Sep 2004 06:10:37 -0000 1.4
@@ -16,6 +16,9 @@
INSERT INTO SECURITY_PRINCIPAL
VALUES(8,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl','/role/user','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_PRINCIPAL
VALUES(9,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl','/user/guest','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_PRINCIPAL
VALUES(10,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl','/role/guest','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL
VALUES(11,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/accounting','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL
VALUES(12,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/marketing','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PRINCIPAL
VALUES(13,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/engineering','2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_CREDENTIAL VALUES(1,1,'admin',0,null,'2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'manager',0,null,'2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,null,'2004-05-22
16:27:12.572','2004-05-22 16:27:12.572');
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
