Changeset: d3c53212ac5e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d3c53212ac5e
Modified Files:
sql/test/scoping/Tests/scoping04.py
Branch: indirect-privs
Log Message:
Permission is required to call udfs
diffs (27 lines):
diff --git a/sql/test/scoping/Tests/scoping04.py
b/sql/test/scoping/Tests/scoping04.py
--- a/sql/test/scoping/Tests/scoping04.py
+++ b/sql/test/scoping/Tests/scoping04.py
@@ -14,6 +14,9 @@ CREATE FUNCTION "sc1"."foo"() RETURNS IN
CREATE FUNCTION "sc2"."foo"() RETURNS INT BEGIN RETURN 2; END;
CREATE FUNCTION "sys"."foo"() RETURNS INT BEGIN RETURN 3; END;
CREATE USER myuser WITH UNENCRYPTED PASSWORD '1' NAME '1' SCHEMA "sys" SCHEMA
PATH '"sc1","sc2"';
+GRANT EXECUTE ON FUNCTION "sc1"."foo"() TO myuser;
+GRANT EXECUTE ON FUNCTION "sc2"."foo"() TO myuser;
+GRANT EXECUTE ON FUNCTION "sys"."foo"() TO myuser;
COMMIT;
''')
cur1.close()
@@ -94,10 +97,13 @@ cur1.execute('''
START TRANSACTION;
CREATE SCHEMA """";
CREATE FUNCTION """".""""() returns int return 5;
+GRANT EXECUTE ON FUNCTION """".""""() TO myuser;
CREATE SCHEMA "😱🤐🤗";
CREATE FUNCTION "😱🤐🤗"."🤓🤯🥶"() returns int return 6;
+GRANT EXECUTE ON FUNCTION "😱🤐🤗"."🤓🤯🥶"() TO myuser;
CREATE SCHEMA ",";
CREATE FUNCTION ",".","() returns int return 7;
+GRANT EXECUTE ON FUNCTION ",".","() TO myuser;
ALTER USER myuser SCHEMA PATH \'"""","😱🤐🤗",","\';
COMMIT;
''')
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
