ate 2004/09/20 12:57:22
Modified: src/sql/oracle populate-userinfo-for-default-psml.sql
Log:
Oracle script synchronized with changes to default and mysql scripts (new roles,
groups)
Revision Changes Path
1.3 +7 -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.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- populate-userinfo-for-default-psml.sql 24 May 2004 04:20:45 -0000 1.2
+++ populate-userinfo-for-default-psml.sql 20 Sep 2004 19:57:22 -0000 1.3
@@ -14,14 +14,21 @@
INSERT INTO SECURITY_PRINCIPAL
VALUES(6,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl','/role/admin',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_PRINCIPAL
VALUES(7,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl','/role/manager',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_PRINCIPAL
VALUES(8,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl','/role/user',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_PRINCIPAL
VALUES(9,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl','/user/guest',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_PRINCIPAL
VALUES(10,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl','/role/guest',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_PRINCIPAL
VALUES(11,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/accounting',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_PRINCIPAL
VALUES(12,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/marketing',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_PRINCIPAL
VALUES(13,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl','/group/engineering',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_CREDENTIAL VALUES(1,1,'admin',0,null,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_CREDENTIAL VALUES(2,2,'manager',0,null,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_CREDENTIAL VALUES(3,3,'user',0,null,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_CREDENTIAL VALUES(4,4,'tomcat',0,null,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_CREDENTIAL VALUES(5,5,'jetspeed',0,null,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_CREDENTIAL VALUES(9,9,'guest',0,null,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_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);
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
