You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by hz...@apache.org on 2016/03/01 23:35:52 UTC
[06/37] incubator-trafodion git commit: Create a role for spj
execution
Create a role for spj execution
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/48949186
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/48949186
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/48949186
Branch: refs/heads/master
Commit: 48949186f6335dc9bf5b63aeeb1275f0999bdf2a
Parents: c5d38bb
Author: Kevin Xu <ka...@esgyn.cn>
Authored: Tue Dec 22 13:55:33 2015 +0800
Committer: Kevin Xu <ka...@esgyn.cn>
Committed: Tue Dec 22 13:55:33 2015 +0800
----------------------------------------------------------------------
core/conn/spj_mgmt/src/main/resources/init_spj.sh | 17 +++++++++--------
1 file changed, 9 insertions(+), 8 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/48949186/core/conn/spj_mgmt/src/main/resources/init_spj.sh
----------------------------------------------------------------------
diff --git a/core/conn/spj_mgmt/src/main/resources/init_spj.sh b/core/conn/spj_mgmt/src/main/resources/init_spj.sh
index 796865c..40d7b51 100644
--- a/core/conn/spj_mgmt/src/main/resources/init_spj.sh
+++ b/core/conn/spj_mgmt/src/main/resources/init_spj.sh
@@ -24,7 +24,7 @@ SERVER_JAR=${MY_SQROOT}/export/lib/spj_mgmt.jar
CI=sqlci
CATALOG_NAME=TRAFODION
CIS_SCHEMA="_SPJ_"
-
+SPJ_EXECROLE=SPJ_EXECROLE
function dropAndCreateSchema {
echo "Creating Schema for SPJ_MGMT"
@@ -56,6 +56,7 @@ function createProcedures {
DROP LIBRARY SPJMGMT CASCADE;
CREATE LIBRARY SPJMGMT FILE '${SERVER_JAR}';
+ CREATE ROLE ${SPJ_EXECROLE};
CREATE PROCEDURE HELP (
INOUT COMMANDNAME VARCHAR(2560) CHARACTER SET ISO88591)
@@ -66,7 +67,7 @@ function createProcedures {
PARAMETER STYLE JAVA
READS SQL DATA
;
- GRANT EXECUTE ON PROCEDURE HELP TO PUBLIC;
+ GRANT EXECUTE ON PROCEDURE HELP TO ${SPJ_EXECROLE};
CREATE PROCEDURE PUT (
IN FILEDATA VARCHAR(102400) CHARACTER SET ISO88591,
@@ -79,7 +80,7 @@ function createProcedures {
PARAMETER STYLE JAVA
READS SQL DATA
;
- GRANT EXECUTE ON PROCEDURE PUT TO PUBLIC;
+ GRANT EXECUTE ON PROCEDURE PUT TO ${SPJ_EXECROLE};
CREATE PROCEDURE LS (
IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
@@ -91,7 +92,7 @@ function createProcedures {
PARAMETER STYLE JAVA
READS SQL DATA
;
- GRANT EXECUTE ON PROCEDURE LS TO PUBLIC;
+ GRANT EXECUTE ON PROCEDURE LS TO ${SPJ_EXECROLE};
CREATE PROCEDURE LSALL (
OUT FILENAMES VARCHAR(10240) CHARACTER SET ISO88591)
@@ -102,7 +103,7 @@ function createProcedures {
PARAMETER STYLE JAVA
READS SQL DATA
;
- GRANT EXECUTE ON PROCEDURE LSALL TO PUBLIC;
+ GRANT EXECUTE ON PROCEDURE LSALL TO ${SPJ_EXECROLE};
CREATE PROCEDURE RM (
IN FILENAME VARCHAR(256) CHARACTER SET ISO88591)
@@ -113,7 +114,7 @@ function createProcedures {
PARAMETER STYLE JAVA
READS SQL DATA
;
- GRANT EXECUTE ON PROCEDURE RM TO PUBLIC;
+ GRANT EXECUTE ON PROCEDURE RM TO ${SPJ_EXECROLE};
CREATE PROCEDURE RMREX (
IN FILENAME VARCHAR(256) CHARACTER SET ISO88591,
@@ -125,7 +126,7 @@ function createProcedures {
PARAMETER STYLE JAVA
READS SQL DATA
;
- GRANT EXECUTE ON PROCEDURE RMREX TO PUBLIC;
+ GRANT EXECUTE ON PROCEDURE RMREX TO ${SPJ_EXECROLE};
CREATE PROCEDURE GETFILE (
IN FILENAME VARCHAR(256) CHARACTER SET UTF8,
@@ -139,7 +140,7 @@ function createProcedures {
PARAMETER STYLE JAVA
READS SQL DATA
;
- GRANT EXECUTE ON PROCEDURE GETFILE TO PUBLIC;
+ GRANT EXECUTE ON PROCEDURE GETFILE TO ${SPJ_EXECROLE};
cqd CAT_IGNORE_ALREADY_EXISTS_ERROR 'off';
cqd CAT_IGNORE_DOES_NOT_EXIST_ERROR 'off';