[
https://issues.apache.org/jira/browse/TRAFODION-1668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15041808#comment-15041808
]
ASF GitHub Bot commented on TRAFODION-1668:
-------------------------------------------
Github user robertamarton commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/203#discussion_r46707640
--- Diff: core/conn/spj_init/src/main/resources/init_spj.sql ---
@@ -0,0 +1,156 @@
+#!/bin/bash
+# @@@ START COPYRIGHT @@@
+#
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
+# @@@ END COPYRIGHT @@@
+
+SERVER_JAR=${MY_SQROOT}/export/lib/spj_init.jar
+CI_SERVER_LOG=${MY_SQROOT}/ciserver/cislog
+SQLCI=${MY_SQROOT}/export/bin32/sqlci
+CP=/bin/cp
+MANAGEABILITY_CATALOG=TRAFODION
+CIS_SCHEMA=DEFAULT_SPJ
+
+
+function dropAndCreateSchema {
+ echo "Creating Schema for CI Server Component"
+ sqlci << sqlciEOF
+
+ cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on';
+ cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on';
+
+ DROP SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA CASCADE;
+ CREATE SCHEMA $MANAGEABILITY_CATALOG.$CIS_SCHEMA;
+
+ cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'off';
+ cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'off';
+
+ exit;
+sqlciEOF
+}
+
+function createProcedures {
+
+ echo "Creating Procedures in schema
'$MANAGEABILITY_CATALOG.$CIS_SCHEMA' "
+ sqlci << procEOF
+
+ cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'on';
+ cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'on';
+
+ -- Creating Procedures
+ set schema $MANAGEABILITY_CATALOG.$CIS_SCHEMA;
+
+ DROP LIBRARY SPJMGMT CASCADE;
+ CREATE LIBRARY SPJMGMT FILE '${SERVER_JAR}';
+
+ CREATE PROCEDURE HELP (
+ INOUT COMMANDNAME VARCHAR(2560) CHARACTER SET ISO88591)
+ EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.help (java.lang.String[])'
+ EXTERNAL SECURITY DEFINER
+ LIBRARY SPJMGMT
+ LANGUAGE JAVA
+ PARAMETER STYLE JAVA
+ READS SQL DATA
+ ;
+ GRANT EXECUTE ON PROCEDURE HELP TO PUBLIC;
+
+ CREATE PROCEDURE PUT (
+ IN FILEDATA VARCHAR(102400) CHARACTER SET ISO88591,
+ IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
+ IN CREATEFLAG INTEGER)
+ EXTERNAL NAME
'com.traf.mgmt.JarFileMgmt.put(java.lang.String,java.lang.String,int)'
+ EXTERNAL SECURITY DEFINER
+ LIBRARY SPJMGMT
+ LANGUAGE JAVA
+ PARAMETER STYLE JAVA
+ READS SQL DATA
+ ;
+ GRANT EXECUTE ON PROCEDURE PUT TO PUBLIC;
+
+ CREATE PROCEDURE LS (
+ IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
+ OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591)
+ EXTERNAL NAME
'com.traf.mgmt.JarFileMgmt.ls(java.lang.String,java.lang.String[])'
+ EXTERNAL SECURITY DEFINER
+ LIBRARY SPJMGMT
+ LANGUAGE JAVA
+ PARAMETER STYLE JAVA
+ READS SQL DATA
+ ;
+ GRANT EXECUTE ON PROCEDURE LS TO PUBLIC;
+
+ CREATE PROCEDURE LSALL (
+ OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591)
+ EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.lsAll(java.lang.String[])'
+ EXTERNAL SECURITY DEFINER
+ LIBRARY SPJMGMT
+ LANGUAGE JAVA
+ PARAMETER STYLE JAVA
+ READS SQL DATA
+ ;
+ GRANT EXECUTE ON PROCEDURE LSALL TO PUBLIC;
+
+ CREATE PROCEDURE RM (
+ IN FILENAME VARCHAR(256) CHARACTER SET ISO88591)
+ EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.rm(java.lang.String)'
+ EXTERNAL SECURITY DEFINER
+ LIBRARY SPJMGMT
+ LANGUAGE JAVA
+ PARAMETER STYLE JAVA
+ READS SQL DATA
+ ;
+ GRANT EXECUTE ON PROCEDURE RM TO PUBLIC;
+
+ CREATE PROCEDURE RMREX (
+ IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
+ OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591)
+ EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.rmRex(java.lang.String,
java.lang.String[])'
+ EXTERNAL SECURITY DEFINER
+ LIBRARY SPJMGMT
+ LANGUAGE JAVA
+ PARAMETER STYLE JAVA
+ READS SQL DATA
+ ;
+ GRANT EXECUTE ON PROCEDURE RMREX TO PUBLIC;
+
+ CREATE PROCEDURE GETFILE (
+ IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
+ IN OFFSET INTEGER,
+ OUT FILEDATA VARCHAR(102400) CHARACTER SET ISO88591,
+ OUT DATALENGTH LARGEINT)
+ EXTERNAL NAME 'com.traf.mgmt.JarFileMgmt.get
(java.lang.String,int,java.lang.String[],long[])'
+ EXTERNAL SECURITY DEFINER
+ LIBRARY SPJMGMT
+ LANGUAGE JAVA
+ PARAMETER STYLE JAVA
+ READS SQL DATA
+ ;
+ GRANT EXECUTE ON PROCEDURE GETFILE TO PUBLIC;
+
+ cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'off';
+ cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'off';
+
+ exit;
+procEOF
+
+}
+
+dropAndCreateSchema
+createProcedures
+echo "Successfully completed installation of SPJs."
--- End diff --
and DB__HBASEROLE. If you want to create a role, you could create one and
call it DB__LIBROLE. However, we already have a component privilege called
MANAGE_LIBRARIES that could be granted to someone or some role. This is a
system level privilege grant.
> Cannot upload customer SPJ JARs
> -------------------------------
>
> Key: TRAFODION-1668
> URL: https://issues.apache.org/jira/browse/TRAFODION-1668
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: Kevin Xu
> Assignee: Kevin Xu
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
