portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Liao <jian.l...@gmail.com>
Subject Re: svn commit: r329115 [3/3] - in /portals/jetspeed-2/trunk/etc: schema/ sql/ sql/hsql/ sql/mssql/ sql/mysql/ sql/oracle/
Date Fri, 28 Oct 2005 12:10:23 GMT
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 <taylor@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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message