Changeset: 6fe9c2c7fa6a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6fe9c2c7fa6a
Modified Files:
sql/test/Users/Tests/grantMonetdb.SQL.py
Branch: default
Log Message:
Fixed query output: a user who has assumed the `sysadmin` role should be able
to create and drop another user
This query currently fails, and is reported in issue #7034
diffs (14 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
@@ -25,8 +25,8 @@ with SQLTestCase() as mdb:
# give alice sysadmin rights
mdb.execute("GRANT sysadmin TO alice;").assertSucceeded()
tc.execute("SET ROLE sysadmin;").assertSucceeded()
- # FIXME: this query should probably not fail
- tc.execute("CREATE USER may WITH PASSWORD 'may' NAME 'May' SCHEMA
library;").assertFailed(err_code='M0M27', err_message="CREATE USER: access
denied for user 'alice'")
+ tc.execute("CREATE USER may WITH PASSWORD 'may' NAME 'May' SCHEMA
library;").assertSucceeded()
+ tc.execute("DROP USER may;").assertSucceeded()
with SQLTestCase() as tc2:
# check that april can only SEL/INS/UPD/DEL the table after the
GRANT ALL
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
