Changeset: 5f1b9a08c6b8 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5f1b9a08c6b8
Added Files:
sql/test/Users/Tests/user_default_role.SQL.py
Modified Files:
sql/test/Users/Tests/All
Branch: userprofile
Log Message:
add test
diffs (28 lines):
diff --git a/sql/test/Users/Tests/All b/sql/test/Users/Tests/All
--- a/sql/test/Users/Tests/All
+++ b/sql/test/Users/Tests/All
@@ -16,3 +16,4 @@ view_privs_chain
unknown_user
userCallFunction
withGrantOption
+user_default_role
diff --git a/sql/test/Users/Tests/user_default_role.SQL.py
b/sql/test/Users/Tests/user_default_role.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/test/Users/Tests/user_default_role.SQL.py
@@ -0,0 +1,15 @@
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ tc.connect(username="monetdb", password="monetdb")
+ tc.execute("create role bartender").assertSucceeded()
+ tc.execute("create table beers(name VARCHAR(20))").assertSucceeded()
+ tc.execute("grant all on beers to bartender").assertSucceeded()
+ tc.execute("create user foo with password 'foo' name 'foo' schema sys
default role bartender").assertSucceeded()
+ with SQLTestCase() as tc:
+ tc.connect(username="foo", password="foo")
+ tc.execute("select current_user").assertValue('foo')
+ tc.execute("select current_role").assertValue('bartender')
+ tc.execute("insert into beers values ('Amstel'), ('Grolsch'),
('Brand')").assertSucceeded()
+ tc.execute("delete from beers").assertSucceeded()
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
