Develop and Download Open Source Software

Portal Application Laboratory

Browse CVS Repository

/[OSDN]/pal/pal-portal/portal/patches/etc/sql/populate-userinfo-for-default-psml.sql

Contents of /pal/pal-portal/portal/patches/etc/sql/populate-userinfo-for-default-psml.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph

Revision 1.5 - (show annotations) (download)
Mon Dec 25 21:55:55 2006 UTC (17 years, 2 months ago) by shinsuke
Branch: MAIN
CVS Tags: RELEASE-1_0_BETA3, RELEASE-1_0_BETA4
Changes since 1.4: +5 -2 lines 
added cms-portlet permission
1 Index: etc/sql/populate-userinfo-for-default-psml.sql
2 ===================================================================
3 --- etc/sql/populate-userinfo-for-default-psml.sql (リビジョン 488564)
4 +++ etc/sql/populate-userinfo-for-default-psml.sql (作業コピー)
5 @@ -6,9 +6,9 @@
6 INSERT INTO PREFS_PROPERTY_VALUE VALUES(41,103,'user.name.given','Test Dude','2004-05-22 16:27:12.562','2004-05-22 16:27:12.562');
7 INSERT INTO PREFS_PROPERTY_VALUE VALUES(42,103,'user.name.family','Dudley','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
8 INSERT INTO SECURITY_PRINCIPAL VALUES(2,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/manager','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
9 -INSERT INTO SECURITY_PRINCIPAL VALUES(3,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/user','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
10 -INSERT INTO SECURITY_PRINCIPAL VALUES(4,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/tomcat','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
11 -INSERT INTO SECURITY_PRINCIPAL VALUES(5,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/jetspeed','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
12 +-- INSERT INTO SECURITY_PRINCIPAL VALUES(3,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/user','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
13 +-- INSERT INTO SECURITY_PRINCIPAL VALUES(4,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/tomcat','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
14 +-- INSERT INTO SECURITY_PRINCIPAL VALUES(5,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/jetspeed','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
15 INSERT INTO SECURITY_PRINCIPAL VALUES(6,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/admin','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
16 INSERT INTO SECURITY_PRINCIPAL VALUES(7,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/manager','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
17 INSERT INTO SECURITY_PRINCIPAL VALUES(8,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/user','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
18 @@ -17,21 +17,23 @@
19 INSERT INTO SECURITY_PRINCIPAL VALUES(11,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/accounting','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
20 INSERT INTO SECURITY_PRINCIPAL VALUES(12,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/marketing','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
21 INSERT INTO SECURITY_PRINCIPAL VALUES(13,'org.apache.jetspeed.security.JetspeedGroupPrincipalImpl',0,1,'/group/engineering','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
22 -INSERT INTO SECURITY_CREDENTIAL VALUES(1,1,'admin',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',1,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
23 -INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'manager',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
24 -INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
25 -INSERT INTO SECURITY_CREDENTIAL VALUES(4,4,'tomcat',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
26 -INSERT INTO SECURITY_CREDENTIAL VALUES(5,5,'jetspeed',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
27 +INSERT INTO SECURITY_PRINCIPAL VALUES(14,'org.apache.jetspeed.security.JetspeedRolePrincipalImpl',0,1,'/role/site','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
28 +INSERT INTO SECURITY_CREDENTIAL VALUES(1,1,'@@ADMIN_PASSWORD@@',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',1,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
29 +INSERT INTO SECURITY_CREDENTIAL VALUES(2,2,'@@MANAGER_PASSWORD@@',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
30 +-- INSERT INTO SECURITY_CREDENTIAL VALUES(3,3,'user',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
31 +-- INSERT INTO SECURITY_CREDENTIAL VALUES(4,4,'tomcat',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
32 +-- INSERT INTO SECURITY_CREDENTIAL VALUES(5,5,'jetspeed',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2004-05-22 16:27:12.572','2004-05-22 16:27:12.572',null,null,null);
33 INSERT INTO SECURITY_USER_ROLE VALUES(1,6);
34 INSERT INTO SECURITY_USER_ROLE VALUES(1,7);
35 INSERT INTO SECURITY_USER_ROLE VALUES(1,8);
36 INSERT INTO SECURITY_USER_ROLE VALUES(2,7);
37 INSERT INTO SECURITY_USER_ROLE VALUES(2,8);
38 -INSERT INTO SECURITY_USER_ROLE VALUES(3,8);
39 +-- INSERT INTO SECURITY_USER_ROLE VALUES(3,8);
40 INSERT INTO SECURITY_USER_ROLE VALUES(9,10);
41 -INSERT INTO SECURITY_USER_ROLE VALUES(5,7);
42 -INSERT INTO SECURITY_USER_GROUP VALUES(3,11);
43 -INSERT INTO SECURITY_USER_GROUP VALUES(5,13);
44 +INSERT INTO SECURITY_USER_ROLE VALUES(9,14);
45 +-- INSERT INTO SECURITY_USER_ROLE VALUES(5,7);
46 +-- INSERT INTO SECURITY_USER_GROUP VALUES(3,11);
47 +-- INSERT INTO SECURITY_USER_GROUP VALUES(5,13);
48 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');
49 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');
50 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');
51 @@ -46,8 +48,8 @@
52 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');
53 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');
54 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');
55 -INSERT INTO PRINCIPAL_PERMISSION VALUES(3,13);
56 -INSERT INTO PRINCIPAL_PERMISSION VALUES(3,14);
57 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(3,13);
58 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(3,14);
59 INSERT INTO PRINCIPAL_PERMISSION VALUES(6,1);
60 INSERT INTO PRINCIPAL_PERMISSION VALUES(7,2);
61 INSERT INTO PRINCIPAL_PERMISSION VALUES(8,3);
62 @@ -63,18 +65,18 @@
63 INSERT INTO PRINCIPAL_PERMISSION VALUES(10,11);
64 INSERT INTO PRINCIPAL_PERMISSION VALUES(10,12);
65
66 -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');
67 -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');
68 -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);
69 -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);
70 +-- 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');
71 +-- 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');
72 +-- 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);
73 +-- 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);
74
75 -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');
76 -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');
77 +-- 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');
78 +-- 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');
79
80 -INSERT INTO SECURITY_USER_ROLE VALUES(50,52);
81 -INSERT INTO SECURITY_USER_ROLE VALUES(50,53);
82 -INSERT INTO SECURITY_USER_ROLE VALUES(51,52);
83 -INSERT INTO SECURITY_USER_ROLE VALUES(51,53);
84 +-- INSERT INTO SECURITY_USER_ROLE VALUES(50,52);
85 +-- INSERT INTO SECURITY_USER_ROLE VALUES(50,53);
86 +-- INSERT INTO SECURITY_USER_ROLE VALUES(51,52);
87 +-- INSERT INTO SECURITY_USER_ROLE VALUES(51,53);
88
89
90 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');
91 @@ -83,21 +85,24 @@
92 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');
93 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');
94 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');
95 -INSERT INTO PRINCIPAL_PERMISSION VALUES(50,52);
96 -INSERT INTO PRINCIPAL_PERMISSION VALUES(50,53);
97 -INSERT INTO PRINCIPAL_PERMISSION VALUES(51,54);
98 -INSERT INTO PRINCIPAL_PERMISSION VALUES(51,55);
99 -INSERT INTO PRINCIPAL_PERMISSION VALUES(52,3);
100 -INSERT INTO PRINCIPAL_PERMISSION VALUES(52,50);
101 -INSERT INTO PRINCIPAL_PERMISSION VALUES(52,51);
102 -INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
103 -INSERT INTO PRINCIPAL_PERMISSION VALUES(53,50);
104 -INSERT INTO PRINCIPAL_PERMISSION VALUES(53,51);
105 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(50,52);
106 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(50,53);
107 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(51,54);
108 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(51,55);
109 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(52,3);
110 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(52,50);
111 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(52,51);
112 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
113 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(53,50);
114 +-- INSERT INTO PRINCIPAL_PERMISSION VALUES(53,51);
115
116 INSERT INTO SECURITY_PERMISSION VALUES(100,'org.apache.jetspeed.security.PortletPermission','j2-admin::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
117 INSERT INTO PRINCIPAL_PERMISSION VALUES(6,100);
118
119 +INSERT INTO SECURITY_PERMISSION VALUES(101,'org.apache.jetspeed.security.PortletPermission','cms-portlets::*','view, edit','2006-12-23 22:37:42','2006-12-23 22:37:42');
120 +INSERT INTO PRINCIPAL_PERMISSION VALUES(14,101);
121 +
122 -- Test User for Mapping IP addresses to geographic locations
123 -- And ip-address Profile rule
124 -INSERT INTO SECURITY_PRINCIPAL VALUES(60,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/geo','2006-09-03 12:07:25.234','2006-09-03 12:07:25.234');
125 -INSERT INTO SECURITY_CREDENTIAL VALUES(60,60,'geo',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2006-09-03 12:07:25.234','2006-09-03 12:07:25.234',null,null,null);
126 \ No newline at end of file
127 +-- INSERT INTO SECURITY_PRINCIPAL VALUES(60,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/geo','2006-09-03 12:07:25.234','2006-09-03 12:07:25.234');
128 +-- INSERT INTO SECURITY_CREDENTIAL VALUES(60,60,'geo',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,'2006-09-03 12:07:25.234','2006-09-03 12:07:25.234',null,null,null);
Back to OSDN">Back to OSDN
 ViewVC Help
Powered by ViewVC 1.1.26  
About OSDN
Find Software
Develop Software
Help