You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ta...@apache.org on 2005/10/28 08:15:06 UTC
svn commit: r329115 [3/3] - in /portals/jetspeed-2/trunk/etc: schema/ sql/
sql/hsql/ sql/mssql/ sql/mysql/ sql/oracle/
Modified: portals/jetspeed-2/trunk/etc/sql/hsql/populate-userinfo-for-default-psml.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/hsql/populate-userinfo-for-default-psml.sql?rev=329115&r1=329114&r2=329115&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/hsql/populate-userinfo-for-default-psml.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/hsql/populate-userinfo-for-default-psml.sql Thu Oct 27 23:15:01 2005
@@ -95,3 +95,11 @@
INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
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','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(101,'org.apache.jetspeed.security.PortletPermission','palm::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(102,'org.apache.jetspeed.security.PortletPermission','pam::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,100);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,101);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,102);
Modified: portals/jetspeed-2/trunk/etc/sql/mssql/populate-userinfo-for-default-psml.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/mssql/populate-userinfo-for-default-psml.sql?rev=329115&r1=329114&r2=329115&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/mssql/populate-userinfo-for-default-psml.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/mssql/populate-userinfo-for-default-psml.sql Thu Oct 27 23:15:01 2005
@@ -95,3 +95,12 @@
INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
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','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(101,'org.apache.jetspeed.security.PortletPermission','palm::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(102,'org.apache.jetspeed.security.PortletPermission','pam::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,100);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,101);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,102);
+
Modified: portals/jetspeed-2/trunk/etc/sql/mysql/populate-userinfo-for-default-psml.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/mysql/populate-userinfo-for-default-psml.sql?rev=329115&r1=329114&r2=329115&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/mysql/populate-userinfo-for-default-psml.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/mysql/populate-userinfo-for-default-psml.sql Thu Oct 27 23:15:01 2005
@@ -95,3 +95,12 @@
INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
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','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(101,'org.apache.jetspeed.security.PortletPermission','palm::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(102,'org.apache.jetspeed.security.PortletPermission','pam::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,100);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,101);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,102);
+
Modified: portals/jetspeed-2/trunk/etc/sql/oracle/populate-userinfo-for-default-psml.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/oracle/populate-userinfo-for-default-psml.sql?rev=329115&r1=329114&r2=329115&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/oracle/populate-userinfo-for-default-psml.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/oracle/populate-userinfo-for-default-psml.sql Thu Oct 27 23:15:01 2005
@@ -95,3 +95,13 @@
INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
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','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(101,'org.apache.jetspeed.security.PortletPermission','palm::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(102,'org.apache.jetspeed.security.PortletPermission','pam::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,100);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,101);
+INSERT INTO PRINCIPAL_PERMISSION VALUES(6,102);
+
+
Modified: portals/jetspeed-2/trunk/etc/sql/populate-userinfo-for-default-psml.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/populate-userinfo-for-default-psml.sql?rev=329115&r1=329114&r2=329115&view=diff
==============================================================================
--- portals/jetspeed-2/trunk/etc/sql/populate-userinfo-for-default-psml.sql (original)
+++ portals/jetspeed-2/trunk/etc/sql/populate-userinfo-for-default-psml.sql Thu Oct 27 23:15:01 2005
@@ -95,3 +95,12 @@
INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
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','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(101,'org.apache.jetspeed.security.PortletPermission','palm::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+INSERT INTO SECURITY_PERMISSION VALUES(102,'org.apache.jetspeed.security.PortletPermission','pam::*','view, edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
+
+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: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
Re: svn commit: r329115 [3/3] - in /portals/jetspeed-2/trunk/etc: schema/ sql/ sql/hsql/ sql/mssql/ sql/mysql/ sql/oracle/
Posted by James Liao <ji...@gmail.com>.
The build for Oracle database broken. The SQL for oracle should be like:
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'));
- James Liao
On 10/28/05, taylor@apache.org <ta...@apache.org> wrote:
>
> Modified: portals/jetspeed-2/trunk/etc/sql/hsql/populate-
> userinfo-for-default-psml.sql
> URL:
> http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/hsql/populate-userinfo-for-default-psml.sql?rev=329115&r1=329114&r2=329115&view=diff
>
> ==============================================================================
> --- portals/jetspeed-2/trunk/etc/sql/hsql/populate-
> userinfo-for-default-psml.sql (original)
> +++ portals/jetspeed-2/trunk/etc/sql/hsql/populate-
> userinfo-for-default-psml.sql Thu Oct 27 23:15:01 2005
> @@ -95,3 +95,11 @@
> INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
> 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','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +INSERT INTO SECURITY_PERMISSION VALUES(101,'
> org.apache.jetspeed.security.PortletPermission','palm::*','view,
> edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +INSERT INTO SECURITY_PERMISSION VALUES(102,'
> org.apache.jetspeed.security.PortletPermission','pam::*','view,
> edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,100);
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,101);
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,102);
>
> Modified: portals/jetspeed-2/trunk/etc/sql/mssql/populate-
> userinfo-for-default-psml.sql
> URL:
> http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/mssql/populate-userinfo-for-default-psml.sql?rev=329115&r1=329114&r2=329115&view=diff
>
> ==============================================================================
> --- portals/jetspeed-2/trunk/etc/sql/mssql/populate-
> userinfo-for-default-psml.sql (original)
> +++ portals/jetspeed-2/trunk/etc/sql/mssql/populate-
> userinfo-for-default-psml.sql Thu Oct 27 23:15:01 2005
> @@ -95,3 +95,12 @@
> INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
> 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','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +INSERT INTO SECURITY_PERMISSION VALUES(101,'
> org.apache.jetspeed.security.PortletPermission','palm::*','view,
> edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +INSERT INTO SECURITY_PERMISSION VALUES(102,'
> org.apache.jetspeed.security.PortletPermission','pam::*','view,
> edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,100);
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,101);
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,102);
> +
>
> Modified: portals/jetspeed-2/trunk/etc/sql/mysql/populate-
> userinfo-for-default-psml.sql
> URL:
> http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/mysql/populate-userinfo-for-default-psml.sql?rev=329115&r1=329114&r2=329115&view=diff
>
> ==============================================================================
> --- portals/jetspeed-2/trunk/etc/sql/mysql/populate-
> userinfo-for-default-psml.sql (original)
> +++ portals/jetspeed-2/trunk/etc/sql/mysql/populate-
> userinfo-for-default-psml.sql Thu Oct 27 23:15:01 2005
> @@ -95,3 +95,12 @@
> INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
> 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','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +INSERT INTO SECURITY_PERMISSION VALUES(101,'
> org.apache.jetspeed.security.PortletPermission','palm::*','view,
> edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +INSERT INTO SECURITY_PERMISSION VALUES(102,'
> org.apache.jetspeed.security.PortletPermission','pam::*','view,
> edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,100);
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,101);
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,102);
> +
>
> Modified: portals/jetspeed-2/trunk/etc/sql/oracle/populate-
> userinfo-for-default-psml.sql
> URL:
> http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/oracle/populate-userinfo-for-default-psml.sql?rev=329115&r1=329114&r2=329115&view=diff
>
> ==============================================================================
> --- portals/jetspeed-2/trunk/etc/sql/oracle/populate-
> userinfo-for-default-psml.sql (original)
> +++ portals/jetspeed-2/trunk/etc/sql/oracle/populate-
> userinfo-for-default-psml.sql Thu Oct 27 23:15:01 2005
> @@ -95,3 +95,13 @@
> INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
> 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','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +INSERT INTO SECURITY_PERMISSION VALUES(101,'
> org.apache.jetspeed.security.PortletPermission','palm::*','view,
> edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +INSERT INTO SECURITY_PERMISSION VALUES(102,'
> org.apache.jetspeed.security.PortletPermission','pam::*','view,
> edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,100);
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,101);
> +INSERT INTO PRINCIPAL_PERMISSION VALUES(6,102);
> +
> +
>
> Modified: portals/jetspeed-2/trunk/etc/sql/populate-
> userinfo-for-default-psml.sql
> URL:
> http://svn.apache.org/viewcvs/portals/jetspeed-2/trunk/etc/sql/populate-userinfo-for-default-psml.sql?rev=329115&r1=329114&r2=329115&view=diff
>
> ==============================================================================
> --- portals/jetspeed-2/trunk/etc/sql/populate-
> userinfo-for-default-psml.sql (original)
> +++ portals/jetspeed-2/trunk/etc/sql/populate-
> userinfo-for-default-psml.sql Thu Oct 27 23:15:01 2005
> @@ -95,3 +95,12 @@
> INSERT INTO PRINCIPAL_PERMISSION VALUES(53,3);
> 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','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +INSERT INTO SECURITY_PERMISSION VALUES(101,'
> org.apache.jetspeed.security.PortletPermission','palm::*','view,
> edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +INSERT INTO SECURITY_PERMISSION VALUES(102,'
> org.apache.jetspeed.security.PortletPermission','pam::*','view,
> edit','2004-05-22 16:27:12.572','2004-05-22 16:27:12.572');
> +
> +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: jetspeed-dev-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
>
>