Changeset: 42a6a71c623e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=42a6a71c623e
Modified Files:
sql/backends/monet5/vaults/bam/85_bam.sql
sql/backends/monet5/vaults/netcdf/74_netcdf.sql
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: Mar2018
Log Message:
Grant permissions for bam and netcdf.
diffs (257 lines):
diff --git a/sql/backends/monet5/vaults/bam/85_bam.sql
b/sql/backends/monet5/vaults/bam/85_bam.sql
--- a/sql/backends/monet5/vaults/bam/85_bam.sql
+++ b/sql/backends/monet5/vaults/bam/85_bam.sql
@@ -107,3 +107,20 @@ CREATE TABLE bam.export (
seq STRING NOT NULL,
qual STRING NOT NULL
);
+
+GRANT SELECT ON bam.files TO PUBLIC;
+GRANT SELECT ON bam.sq TO PUBLIC;
+GRANT SELECT ON bam.rg TO PUBLIC;
+GRANT SELECT ON bam.pg TO PUBLIC;
+GRANT SELECT ON bam.export TO PUBLIC;
+GRANT EXECUTE ON FUNCTION bam.bam_flag(SMALLINT, STRING) TO PUBLIC;
+GRANT EXECUTE ON FUNCTION bam.reverse_seq(STRING) TO PUBLIC;
+GRANT EXECUTE ON FUNCTION bam.reverse_qual(STRING) TO PUBLIC;
+GRANT EXECUTE ON FUNCTION bam.seq_length(STRING) TO PUBLIC;
+GRANT EXECUTE ON FUNCTION bam.seq_char(INT, STRING, INT, STRING) TO PUBLIC;
+GRANT EXECUTE ON PROCEDURE bam.bam_loader_repos(STRING, SMALLINT) TO PUBLIC;
+GRANT EXECUTE ON PROCEDURE bam.bam_loader_files(STRING, SMALLINT) TO PUBLIC;
+GRANT EXECUTE ON PROCEDURE bam.bam_loader_file(STRING, SMALLINT) TO PUBLIC;
+GRANT EXECUTE ON PROCEDURE bam.bam_drop_file(BIGINT, SMALLINT) TO PUBLIC;
+GRANT EXECUTE ON PROCEDURE bam.sam_export(STRING) TO PUBLIC;
+GRANT EXECUTE ON PROCEDURE bam.bam_export(STRING) TO PUBLIC;
diff --git a/sql/backends/monet5/vaults/netcdf/74_netcdf.sql
b/sql/backends/monet5/vaults/netcdf/74_netcdf.sql
--- a/sql/backends/monet5/vaults/netcdf/74_netcdf.sql
+++ b/sql/backends/monet5/vaults/netcdf/74_netcdf.sql
@@ -1,3 +1,8 @@
+-- This Source Code Form is subject to the terms of the Mozilla Public
+-- License, v. 2.0. If a copy of the MPL was not distributed with this
+-- file, You can obtain one at http://mozilla.org/MPL/2.0/.
+--
+-- Copyright 1997 - July 2008 CWI, August 2008 - 2018 MonetDB B.V.
create table netcdf_files(
file_id int,
@@ -44,3 +49,10 @@ create procedure netcdf_attach(fname var
create procedure netcdf_importvar(fid integer, varnname varchar(256))
external name netcdf.importvariable;
+grant select on netcdf_files to public;
+grant select on netcdf_dims to public;
+grant select on netcdf_vars to public;
+grant select on netcdf_vardim to public;
+grant select on netcdf_attrs to public;
+grant execute on procedure netcdf_attach(varchar(256)) to public;
+grant execute on procedure netcdf_importvar(integer, varchar(256)) to public;
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -4661,6 +4661,8 @@ drop function pcre_replace(string, strin
[ "dependency_views_on_views", "public", "SELECT", "monetdb",
0 ]
[ "describe_all_objects", "public", "SELECT", "monetdb",
0 ]
[ "environment", "public", "SELECT", "monetdb", 0
]
+[ "export", "public", "SELECT", "monetdb", 0 ]
+[ "files", "public", "SELECT", "monetdb", 0 ]
[ "function_languages", "public", "SELECT", "monetdb",
0 ]
[ "function_types", "public", "SELECT", "monetdb", 0
]
[ "functions", "public", "SELECT", NULL, 0 ]
@@ -4671,13 +4673,21 @@ drop function pcre_replace(string, strin
[ "key_types", "public", "SELECT", "monetdb", 0 ]
[ "keys", "public", "SELECT", NULL, 0 ]
[ "keywords", "public", "SELECT", "monetdb", 0 ]
+[ "netcdf_attrs", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_dims", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_files", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_vardim", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_vars", "public", "SELECT", "monetdb", 0
]
[ "objects", "public", "SELECT", NULL, 0 ]
+[ "pg", "public", "SELECT", "monetdb", 0 ]
[ "privilege_codes", "public", "SELECT", "monetdb", 0
]
[ "privileges", "public", "SELECT", NULL, 0 ]
+[ "rg", "public", "SELECT", "monetdb", 0 ]
[ "roles", "public", "SELECT", "monetdb", 0 ]
[ "schemas", "public", "SELECT", NULL, 0 ]
[ "sequences", "public", "SELECT", NULL, 0 ]
[ "spatial_ref_sys", "public", "SELECT", "monetdb", 0
]
+[ "sq", "public", "SELECT", "monetdb", 0 ]
[ "systemfunctions", "public", "SELECT", "monetdb", 0
]
[ "table_types", "public", "SELECT", "monetdb", 0
]
[ "tables", "public", "SELECT", NULL, 0 ]
@@ -4697,6 +4707,12 @@ drop function pcre_replace(string, strin
% 21, 6, 7, 7, 1 # length
[ "abbrev", "public", "EXECUTE", "monetdb", 0 ]
[ "alpha", "public", "EXECUTE", "monetdb", 0 ]
+[ "bam_drop_file", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_export", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_flag", "public", "EXECUTE", "monetdb", 0 ]
+[ "bam_loader_file", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_loader_files", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_loader_repos", "public", "EXECUTE", "monetdb", 0
]
[ "broadcast", "public", "EXECUTE", "monetdb", 0 ]
[ "contains", "public", "EXECUTE", "monetdb", 0 ]
[ "corr", "public", "EXECUTE", "monetdb", 0 ]
@@ -4772,6 +4788,8 @@ drop function pcre_replace(string, strin
[ "ms_str", "public", "EXECUTE", "monetdb", 0 ]
[ "ms_stuff", "public", "EXECUTE", "monetdb", 0 ]
[ "ms_trunc", "public", "EXECUTE", "monetdb", 0 ]
+[ "netcdf_attach", "public", "EXECUTE", "monetdb", 0
]
+[ "netcdf_importvar", "public", "EXECUTE", "monetdb", 0
]
[ "netmask", "public", "EXECUTE", "monetdb", 0 ]
[ "network", "public", "EXECUTE", "monetdb", 0 ]
[ "newurl", "public", "EXECUTE", "monetdb", 0 ]
@@ -4790,8 +4808,13 @@ drop function pcre_replace(string, strin
[ "quantile", "public", "EXECUTE", "monetdb", 0 ]
[ "radians", "public", "EXECUTE", "monetdb", 0 ]
[ "rejects", "public", "EXECUTE", "monetdb", 0 ]
+[ "reverse_qual", "public", "EXECUTE", "monetdb", 0
]
+[ "reverse_seq", "public", "EXECUTE", "monetdb", 0
]
[ "right_shift", "public", "EXECUTE", "monetdb", 0
]
[ "right_shift_assign", "public", "EXECUTE", "monetdb",
0 ]
+[ "sam_export", "public", "EXECUTE", "monetdb", 0
]
+[ "seq_char", "public", "EXECUTE", "monetdb", 0 ]
+[ "seq_length", "public", "EXECUTE", "monetdb", 0
]
[ "setmasklen", "public", "EXECUTE", "monetdb", 0
]
[ "st_area", "public", "EXECUTE", "monetdb", 0 ]
[ "st_asbinary", "public", "EXECUTE", "monetdb", 0
]
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -4665,6 +4665,8 @@ drop function pcre_replace(string, strin
[ "dependency_views_on_views", "public", "SELECT", "monetdb",
0 ]
[ "describe_all_objects", "public", "SELECT", "monetdb",
0 ]
[ "environment", "public", "SELECT", "monetdb", 0
]
+[ "export", "public", "SELECT", "monetdb", 0 ]
+[ "files", "public", "SELECT", "monetdb", 0 ]
[ "function_languages", "public", "SELECT", "monetdb",
0 ]
[ "function_types", "public", "SELECT", "monetdb", 0
]
[ "functions", "public", "SELECT", NULL, 0 ]
@@ -4675,13 +4677,21 @@ drop function pcre_replace(string, strin
[ "key_types", "public", "SELECT", "monetdb", 0 ]
[ "keys", "public", "SELECT", NULL, 0 ]
[ "keywords", "public", "SELECT", "monetdb", 0 ]
+[ "netcdf_attrs", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_dims", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_files", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_vardim", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_vars", "public", "SELECT", "monetdb", 0
]
[ "objects", "public", "SELECT", NULL, 0 ]
+[ "pg", "public", "SELECT", "monetdb", 0 ]
[ "privilege_codes", "public", "SELECT", "monetdb", 0
]
[ "privileges", "public", "SELECT", NULL, 0 ]
+[ "rg", "public", "SELECT", "monetdb", 0 ]
[ "roles", "public", "SELECT", "monetdb", 0 ]
[ "schemas", "public", "SELECT", NULL, 0 ]
[ "sequences", "public", "SELECT", NULL, 0 ]
[ "spatial_ref_sys", "public", "SELECT", "monetdb", 0
]
+[ "sq", "public", "SELECT", "monetdb", 0 ]
[ "systemfunctions", "public", "SELECT", "monetdb", 0
]
[ "table_types", "public", "SELECT", "monetdb", 0
]
[ "tables", "public", "SELECT", NULL, 0 ]
@@ -4701,6 +4711,12 @@ drop function pcre_replace(string, strin
% 21, 6, 7, 7, 1 # length
[ "abbrev", "public", "EXECUTE", "monetdb", 0 ]
[ "alpha", "public", "EXECUTE", "monetdb", 0 ]
+[ "bam_drop_file", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_export", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_flag", "public", "EXECUTE", "monetdb", 0 ]
+[ "bam_loader_file", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_loader_files", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_loader_repos", "public", "EXECUTE", "monetdb", 0
]
[ "broadcast", "public", "EXECUTE", "monetdb", 0 ]
[ "contains", "public", "EXECUTE", "monetdb", 0 ]
[ "corr", "public", "EXECUTE", "monetdb", 0 ]
@@ -4776,6 +4792,8 @@ drop function pcre_replace(string, strin
[ "ms_str", "public", "EXECUTE", "monetdb", 0 ]
[ "ms_stuff", "public", "EXECUTE", "monetdb", 0 ]
[ "ms_trunc", "public", "EXECUTE", "monetdb", 0 ]
+[ "netcdf_attach", "public", "EXECUTE", "monetdb", 0
]
+[ "netcdf_importvar", "public", "EXECUTE", "monetdb", 0
]
[ "netmask", "public", "EXECUTE", "monetdb", 0 ]
[ "network", "public", "EXECUTE", "monetdb", 0 ]
[ "newurl", "public", "EXECUTE", "monetdb", 0 ]
@@ -4794,8 +4812,13 @@ drop function pcre_replace(string, strin
[ "quantile", "public", "EXECUTE", "monetdb", 0 ]
[ "radians", "public", "EXECUTE", "monetdb", 0 ]
[ "rejects", "public", "EXECUTE", "monetdb", 0 ]
+[ "reverse_qual", "public", "EXECUTE", "monetdb", 0
]
+[ "reverse_seq", "public", "EXECUTE", "monetdb", 0
]
[ "right_shift", "public", "EXECUTE", "monetdb", 0
]
[ "right_shift_assign", "public", "EXECUTE", "monetdb",
0 ]
+[ "sam_export", "public", "EXECUTE", "monetdb", 0
]
+[ "seq_char", "public", "EXECUTE", "monetdb", 0 ]
+[ "seq_length", "public", "EXECUTE", "monetdb", 0
]
[ "setmasklen", "public", "EXECUTE", "monetdb", 0
]
[ "st_area", "public", "EXECUTE", "monetdb", 0 ]
[ "st_asbinary", "public", "EXECUTE", "monetdb", 0
]
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -4862,6 +4862,8 @@ drop function pcre_replace(string, strin
[ "dependency_views_on_views", "public", "SELECT", "monetdb",
0 ]
[ "describe_all_objects", "public", "SELECT", "monetdb",
0 ]
[ "environment", "public", "SELECT", "monetdb", 0
]
+[ "export", "public", "SELECT", "monetdb", 0 ]
+[ "files", "public", "SELECT", "monetdb", 0 ]
[ "function_languages", "public", "SELECT", "monetdb",
0 ]
[ "function_types", "public", "SELECT", "monetdb", 0
]
[ "functions", "public", "SELECT", NULL, 0 ]
@@ -4872,13 +4874,21 @@ drop function pcre_replace(string, strin
[ "key_types", "public", "SELECT", "monetdb", 0 ]
[ "keys", "public", "SELECT", NULL, 0 ]
[ "keywords", "public", "SELECT", "monetdb", 0 ]
+[ "netcdf_attrs", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_dims", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_files", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_vardim", "public", "SELECT", "monetdb", 0
]
+[ "netcdf_vars", "public", "SELECT", "monetdb", 0
]
[ "objects", "public", "SELECT", NULL, 0 ]
+[ "pg", "public", "SELECT", "monetdb", 0 ]
[ "privilege_codes", "public", "SELECT", "monetdb", 0
]
[ "privileges", "public", "SELECT", NULL, 0 ]
+[ "rg", "public", "SELECT", "monetdb", 0 ]
[ "roles", "public", "SELECT", "monetdb", 0 ]
[ "schemas", "public", "SELECT", NULL, 0 ]
[ "sequences", "public", "SELECT", NULL, 0 ]
[ "spatial_ref_sys", "public", "SELECT", "monetdb", 0
]
+[ "sq", "public", "SELECT", "monetdb", 0 ]
[ "systemfunctions", "public", "SELECT", "monetdb", 0
]
[ "table_types", "public", "SELECT", "monetdb", 0
]
[ "tables", "public", "SELECT", NULL, 0 ]
@@ -4898,6 +4908,12 @@ drop function pcre_replace(string, strin
% 21, 6, 7, 7, 1 # length
[ "abbrev", "public", "EXECUTE", "monetdb", 0 ]
[ "alpha", "public", "EXECUTE", "monetdb", 0 ]
+[ "bam_drop_file", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_export", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_flag", "public", "EXECUTE", "monetdb", 0 ]
+[ "bam_loader_file", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_loader_files", "public", "EXECUTE", "monetdb", 0
]
+[ "bam_loader_repos", "public", "EXECUTE", "monetdb", 0
]
[ "broadcast", "public", "EXECUTE", "monetdb", 0 ]
[ "contains", "public", "EXECUTE", "monetdb", 0 ]
[ "corr", "public", "EXECUTE", "monetdb", 0 ]
@@ -4976,6 +4992,8 @@ drop function pcre_replace(string, strin
[ "ms_str", "public", "EXECUTE", "monetdb", 0 ]
[ "ms_stuff", "public", "EXECUTE", "monetdb", 0 ]
[ "ms_trunc", "public", "EXECUTE", "monetdb", 0 ]
+[ "netcdf_attach", "public", "EXECUTE", "monetdb", 0
]
+[ "netcdf_importvar", "public", "EXECUTE", "monetdb", 0
]
[ "netmask", "public", "EXECUTE", "monetdb", 0 ]
[ "network", "public", "EXECUTE", "monetdb", 0 ]
[ "newurl", "public", "EXECUTE", "monetdb", 0 ]
@@ -4995,8 +5013,13 @@ drop function pcre_replace(string, strin
[ "quantile", "public", "EXECUTE", "monetdb", 0 ]
[ "radians", "public", "EXECUTE", "monetdb", 0 ]
[ "rejects", "public", "EXECUTE", "monetdb", 0 ]
+[ "reverse_qual", "public", "EXECUTE", "monetdb", 0
]
+[ "reverse_seq", "public", "EXECUTE", "monetdb", 0
]
[ "right_shift", "public", "EXECUTE", "monetdb", 0
]
[ "right_shift_assign", "public", "EXECUTE", "monetdb",
0 ]
+[ "sam_export", "public", "EXECUTE", "monetdb", 0
]
+[ "seq_char", "public", "EXECUTE", "monetdb", 0 ]
+[ "seq_length", "public", "EXECUTE", "monetdb", 0
]
[ "setmasklen", "public", "EXECUTE", "monetdb", 0
]
[ "st_area", "public", "EXECUTE", "monetdb", 0 ]
[ "st_asbinary", "public", "EXECUTE", "monetdb", 0
]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
