Changeset: 3aacb07c890c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3aacb07c890c
Modified Files:
        sql/test/Users/Tests/grantMonetdb.SQL.py
Branch: mtest
Log Message:

fix user test


diffs (22 lines):

diff --git a/sql/test/Users/Tests/grantMonetdb.SQL.py 
b/sql/test/Users/Tests/grantMonetdb.SQL.py
--- a/sql/test/Users/Tests/grantMonetdb.SQL.py
+++ b/sql/test/Users/Tests/grantMonetdb.SQL.py
@@ -7,12 +7,13 @@ from MonetDBtesting.sqltest import SQLTe
 
 with SQLTestCase() as tc:
     tc.connect(username="monetdb", password="monetdb")
-    tc.execute("GRANT sysadmin TO alice;")
+    tc.execute("GRANT sysadmin TO alice;").assertSucceeded()
     tc.connect(username="alice", password="alice")
-    tc.execute("SET ROLE sysadmin;")
-    tc.execute("CREATE USER may WITH PASSWORD 'may' NAME 'May' SCHEMA 
library;")
-    tc.execute("GRANT ALL ON orders TO april;")
-    tc.execute("GRANT sysadmin TO april;")
+    tc.execute("""
+    SET ROLE sysadmin;
+    CREATE USER may WITH PASSWORD 'may' NAME 'May' SCHEMA 
library;""").assertFailed(err_code='M0M27')
+    tc.execute("GRANT ALL ON orders TO april;").assertSucceeded()
+    tc.execute("GRANT sysadmin TO april;").assertFailed(err_code='0P000')
 
 # import os, sys
 # try:
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to