From a0e0d91eb07d522c09819715ae6038dfc51ec2aa Mon Sep 17 00:00:00 2001 From: Sweidan Omar Date: Mon, 6 Dec 2021 10:29:37 +0000 Subject: [PATCH] git-tfs-id: [http://tfs.userrendszerhaz.hu:8080/tfs/DefaultCollection]$/MediaCube;C32430 --- .../sql/grantPermission.db2 | 29 +++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 server/user.jobengine.osgi.db/sql/grantPermission.db2 diff --git a/server/user.jobengine.osgi.db/sql/grantPermission.db2 b/server/user.jobengine.osgi.db/sql/grantPermission.db2 new file mode 100644 index 00000000..ecd02548 --- /dev/null +++ b/server/user.jobengine.osgi.db/sql/grantPermission.db2 @@ -0,0 +1,29 @@ +-- Change to your JSON database name + +connect to mc; + +grant select on systools.sysjson_index to user db2admin; +grant insert on systools.sysjson_index to user db2admin; +grant delete on systools.sysjson_index to user db2admin; + +grant execute on function systools.json_val2 to user db2admin; +grant execute on function systools.json_binary to user db2admin; +grant execute on function systools.json_binary2 to user db2admin; +grant execute on function systools.json_table to user db2admin; +grant execute on function systools.json_table_binary to user db2admin; +grant execute on function systools.json_len to user db2admin; +grant execute on function systools.json_type to user db2admin; +grant execute on function systools.json2bson to user db2admin; +grant execute on function systools.bson2json to user db2admin; +grant execute on function systools.bson_validate to user db2admin; +grant execute on function systools.json_get_pos_arr_index to user db2admin; + +grant execute on function systools.json_update(BLOB(16M), VARCHAR(256), VARCHAR(32672), VARCHAR(32672) FOR BIT DATA, INTEGER) to user db2admin; + +grant execute on function systools.json_update(BLOB(16M), VARCHAR(32672)) to user db2admin; + +grant execute on specific function systools.REG_MATCHES_NOFLAGS to user db2admin; + +grant execute on specific function systools.REG_MATCHES to user db2admin; + +connect reset; \ No newline at end of file -- 2.54.0