Author: ate
Date: Fri Apr 14 07:51:32 2006
New Revision: 394111
URL: http://svn.apache.org/viewcvs?rev=394111&view=rev
Log:
Fixing incorrect PortletPermission definitions on PostgreSQL for restricted
access to the j2-admin.
The script still referred to the "old" security, pam and palm portlet
applications which have been merged into the j2-admin long time ago.
See also JS2-478, which mentions MySQL but brought this PostgreSQL problem to
my attention.
Modified:
portals/jetspeed-2/trunk/etc/sql/postgres/populate-userinfo-for-default-psml.sql
Modified:
portals/jetspeed-2/trunk/etc/sql/postgres/populate-userinfo-for-default-psml.sql
URL:
http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/postgres/populate-userinfo-for-default-psml.sql?rev=394111&r1=394110&r2=394111&view=diff
==============================================================================
---
portals/jetspeed-2/trunk/etc/sql/postgres/populate-userinfo-for-default-psml.sql
(original)
+++
portals/jetspeed-2/trunk/etc/sql/postgres/populate-userinfo-for-default-psml.sql
Fri Apr 14 07:51:32 2006
@@ -63,7 +63,6 @@
INSERT INTO PRINCIPAL_PERMISSION VALUES(10,11);
INSERT INTO PRINCIPAL_PERMISSION VALUES(10,12);
-
INSERT INTO SECURITY_PRINCIPAL
VALUES(50,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite',to_date('2005-01-01
00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-01-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'));
INSERT INTO SECURITY_PRINCIPAL
VALUES(51,'org.apache.jetspeed.security.JetspeedUserPrincipalImpl',0,1,'/user/subsite2',to_date('2005-01-01
00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-01-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'));
INSERT INTO SECURITY_CREDENTIAL
VALUES(50,50,'subsite',0,'org.apache.jetspeed.security.spi.impl.DefaultPasswordCredentialImpl',0,0,1,0,0,to_date('2005-01-01
00:00:00','YYYY-MM-DD HH24:MI:SS'),to_date('2005-01-01 00:00:00','YYYY-MM-DD
HH24:MI:SS'),null,null,null);
@@ -77,6 +76,7 @@
INSERT INTO SECURITY_USER_ROLE VALUES(51,52);
INSERT INTO SECURITY_USER_ROLE VALUES(51,53);
+
INSERT INTO SECURITY_PERMISSION
VALUES(50,'org.apache.jetspeed.security.FolderPermission','/__subsite-root','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(51,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/-','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(52,'org.apache.jetspeed.security.FolderPermission','/__subsite-root/_role/subsite','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'));
@@ -94,12 +94,6 @@
INSERT INTO PRINCIPAL_PERMISSION VALUES(53,50);
INSERT INTO PRINCIPAL_PERMISSION VALUES(53,51);
-INSERT INTO SECURITY_PERMISSION
VALUES(100,'org.apache.jetspeed.security.PortletPermission','security::*','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(101,'org.apache.jetspeed.security.PortletPermission','palm::*','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(102,'org.apache.jetspeed.security.PortletPermission','pam::*','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(100,'org.apache.jetspeed.security.PortletPermission','j2-admin::*','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(6,100);
-INSERT INTO PRINCIPAL_PERMISSION VALUES(6,101);
-INSERT INTO PRINCIPAL_PERMISSION VALUES(6,102);
-
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
