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 <[email protected]> Authored: Tue Dec 22 13:55:33 2015 +0800 Committer: Kevin Xu <[email protected]> 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';
