Changeset: 68e3f04a3437 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=68e3f04a3437 Modified Files: sql/test/Users/Tests/role1.SQL.py sql/test/Users/Tests/role2.SQL.py sql/test/Users/Tests/table.SQL.py sql/test/Users/Tests/test_privs2_p1.SQL.py sql/test/Users/Tests/test_privs2_p2.SQL.py sql/test/Users/Tests/test_privs_p1.SQL.py sql/test/Users/Tests/test_privs_p2.SQL.py sql/test/Users/Tests/unknown_user.SQL.py Branch: default Log Message:
Described the already existing test cases from sql/test/Users/Tests. diffs (92 lines): diff --git a/sql/test/Users/Tests/role1.SQL.py b/sql/test/Users/Tests/role1.SQL.py --- a/sql/test/Users/Tests/role1.SQL.py +++ b/sql/test/Users/Tests/role1.SQL.py @@ -1,3 +1,7 @@ +### +# SET a GRANTed ROLE for a USER (possible). +### + import os, sys try: from MonetDBtesting import process diff --git a/sql/test/Users/Tests/role2.SQL.py b/sql/test/Users/Tests/role2.SQL.py --- a/sql/test/Users/Tests/role2.SQL.py +++ b/sql/test/Users/Tests/role2.SQL.py @@ -1,3 +1,7 @@ +### +# SET a non-GRANTed ROLE for a USER (not possible). +### + import os, sys try: from MonetDBtesting import process diff --git a/sql/test/Users/Tests/table.SQL.py b/sql/test/Users/Tests/table.SQL.py --- a/sql/test/Users/Tests/table.SQL.py +++ b/sql/test/Users/Tests/table.SQL.py @@ -1,3 +1,8 @@ +### +# SET a GRANTed ROLE for a USER (possible). +# CREATE TABLE and INSERT (possible). +### + import os, sys try: from MonetDBtesting import process diff --git a/sql/test/Users/Tests/test_privs2_p1.SQL.py b/sql/test/Users/Tests/test_privs2_p1.SQL.py --- a/sql/test/Users/Tests/test_privs2_p1.SQL.py +++ b/sql/test/Users/Tests/test_privs2_p1.SQL.py @@ -1,3 +1,8 @@ +### +# Use functions that contain SELECT. INSERT, UPDATE, DELETE +# on a table for which the USER has GRANTs (possible). +### + import os, sys try: from MonetDBtesting import process diff --git a/sql/test/Users/Tests/test_privs2_p2.SQL.py b/sql/test/Users/Tests/test_privs2_p2.SQL.py --- a/sql/test/Users/Tests/test_privs2_p2.SQL.py +++ b/sql/test/Users/Tests/test_privs2_p2.SQL.py @@ -1,3 +1,9 @@ +### +# Use functions that contain SELECT. INSERT, UPDATE, DELETE on a +# table for which the USER does *not* have GRANTs (not possible). +### + + import os, sys try: from MonetDBtesting import process diff --git a/sql/test/Users/Tests/test_privs_p1.SQL.py b/sql/test/Users/Tests/test_privs_p1.SQL.py --- a/sql/test/Users/Tests/test_privs_p1.SQL.py +++ b/sql/test/Users/Tests/test_privs_p1.SQL.py @@ -1,3 +1,7 @@ +### +# SELECT, INSERT, UPDATE, DELETE a table for which the USER has GRANTs (possible). +### + import os, sys try: from MonetDBtesting import process diff --git a/sql/test/Users/Tests/test_privs_p2.SQL.py b/sql/test/Users/Tests/test_privs_p2.SQL.py --- a/sql/test/Users/Tests/test_privs_p2.SQL.py +++ b/sql/test/Users/Tests/test_privs_p2.SQL.py @@ -1,3 +1,7 @@ +### +# SELECT, INSERT, UPDATE, DELETE a table for which the USER does *not* have GRANTs (not possible). +### + import os, sys try: from MonetDBtesting import process diff --git a/sql/test/Users/Tests/unknown_user.SQL.py b/sql/test/Users/Tests/unknown_user.SQL.py --- a/sql/test/Users/Tests/unknown_user.SQL.py +++ b/sql/test/Users/Tests/unknown_user.SQL.py @@ -1,3 +1,7 @@ +### +# Authenticate unknown USER (not possible). +### + import sys try: from MonetDBtesting import process _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list