Changeset: cecf22a6785b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cecf22a6785b
Modified Files:
sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py
Branch: mtest
Log Message:
add grantAndRevokeUserLoggedIn tests
diffs (153 lines):
diff --git a/sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py
b/sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py
--- a/sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py
+++ b/sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py
@@ -3,65 +3,97 @@
# Assess that a user can no longer use the privilege as soon as it was revoked.
###
-import sys, time, pymonetdb, os
+from MonetDBtesting.sqltest import SQLTestCase
+
+with SQLTestCase() as tc:
+ tc.connect(username="monetdb", password="monetdb")
+ tc.execute('CREATE SCHEMA new_schema_as_well')
+ tc.execute('SET SCHEMA new_schema_as_well')
+ tc.execute('CREATE TABLE test (x int, y int)')
+ tc.execute('INSERT INTO test VALUES (-1, -1)')
-def connect(username, password):
- return pymonetdb.connect(database = os.getenv('TSTDB'),
- hostname = 'localhost',
- port = int(os.getenv('MAPIPORT')),
- username = username,
- password = password,
- autocommit = True)
+ # Create a new user and grant the right to select.
+ tc.execute('CREATE USER new_user WITH PASSWORD \'new_quite_long_password\'
NAME \'newUser\' SCHEMA new_schema_as_well')
+ tc.execute('GRANT SELECT ON new_schema_as_well.test TO new_user')
+ tc.execute('GRANT UPDATE ON new_schema_as_well.test TO new_user')
+ tc.execute('GRANT INSERT ON new_schema_as_well.test TO new_user')
+ tc.execute('GRANT DELETE ON new_schema_as_well.test TO new_user')
+
+ # Login the new user, and select.
+ tc.connect(username='new_user', password='new_quite_long_password')
+ tc.execute('SELECT * FROM test')
+ tc.execute('UPDATE test SET x = -3 WHERE y = -1')
+ tc.execute('INSERT INTO test VALUES (0, 0)')
+ tc.execute('DELETE FROM test WHERE y = -2')
+
+ # Revoke the right to select from the new user.
+ tc.execute('REVOKE SELECT ON new_schema_as_well.test FROM new_user')
-def query(conn, sql):
- print(sql)
- cur = conn.cursor()
- try:
- cur.execute(sql)
- except pymonetdb.OperationalError as e:
- print("!", e)
- return
- r = cur.fetchall()
- cur.close()
- print(r)
+ # The new user should not be able to select anymore.
+ tc.execute('UPDATE test SET x = -66 WHERE y = 66')
+ tc.execute('INSERT INTO test VALUES (66, 66)')
+ tc.execute('DELETE FROM test WHERE y = -66')
+ tc.execute('SELECT * FROM test')
+
+# import sys, time, pymonetdb, os
+
+# def connect(username, password):
+# return pymonetdb.connect(database = os.getenv('TSTDB'),
+# hostname = 'localhost',
+# port = int(os.getenv('MAPIPORT')),
+# username = username,
+# password = password,
+# autocommit = True)
-def run(conn, sql):
- print(sql)
- try:
- r = conn.execute(sql)
- except pymonetdb.OperationalError as e:
- print("!", e)
- return
- print('# OK')
+# def query(conn, sql):
+# print(sql)
+# cur = conn.cursor()
+# try:
+# cur.execute(sql)
+# except pymonetdb.OperationalError as e:
+# print("!", e)
+# return
+# r = cur.fetchall()
+# cur.close()
+# print(r)
+
+# def run(conn, sql):
+# print(sql)
+# try:
+# r = conn.execute(sql)
+# except pymonetdb.OperationalError as e:
+# print("!", e)
+# return
+# print('# OK')
-c1 = connect('monetdb', 'monetdb')
-# Create a new schema with a new table.
-run(c1, 'CREATE SCHEMA new_schema_as_well')
-run(c1, 'SET SCHEMA new_schema_as_well')
-run(c1, 'CREATE TABLE test (x int, y int)')
-run(c1, 'INSERT INTO test VALUES (-1, -1)')
+# c1 = connect('monetdb', 'monetdb')
+# # Create a new schema with a new table.
+# run(c1, 'CREATE SCHEMA new_schema_as_well')
+# run(c1, 'SET SCHEMA new_schema_as_well')
+# run(c1, 'CREATE TABLE test (x int, y int)')
+# run(c1, 'INSERT INTO test VALUES (-1, -1)')
-# Create a new user and grant the right to select.
-run(c1, 'CREATE USER new_user WITH PASSWORD \'new_quite_long_password\' NAME
\'newUser\' SCHEMA new_schema_as_well')
-run(c1, 'GRANT SELECT ON new_schema_as_well.test TO new_user')
-run(c1, 'GRANT UPDATE ON new_schema_as_well.test TO new_user')
-run(c1, 'GRANT INSERT ON new_schema_as_well.test TO new_user')
-run(c1, 'GRANT DELETE ON new_schema_as_well.test TO new_user')
+# # Create a new user and grant the right to select.
+# run(c1, 'CREATE USER new_user WITH PASSWORD \'new_quite_long_password\' NAME
\'newUser\' SCHEMA new_schema_as_well')
+# run(c1, 'GRANT SELECT ON new_schema_as_well.test TO new_user')
+# run(c1, 'GRANT UPDATE ON new_schema_as_well.test TO new_user')
+# run(c1, 'GRANT INSERT ON new_schema_as_well.test TO new_user')
+# run(c1, 'GRANT DELETE ON new_schema_as_well.test TO new_user')
-# Login the new user, and select.
-c2 = connect('new_user', 'new_quite_long_password')
-query(c2, 'SELECT * FROM test')
-run(c2, 'UPDATE test SET x = -3 WHERE y = -1')
-run(c2, 'INSERT INTO test VALUES (0, 0)')
-run(c2, 'DELETE FROM test WHERE y = -2')
+# # Login the new user, and select.
+# c2 = connect('new_user', 'new_quite_long_password')
+# query(c2, 'SELECT * FROM test')
+# run(c2, 'UPDATE test SET x = -3 WHERE y = -1')
+# run(c2, 'INSERT INTO test VALUES (0, 0)')
+# run(c2, 'DELETE FROM test WHERE y = -2')
-# Revoke the right to select from the new user.
-run(c1, 'REVOKE SELECT ON new_schema_as_well.test FROM new_user')
+# # Revoke the right to select from the new user.
+# run(c1, 'REVOKE SELECT ON new_schema_as_well.test FROM new_user')
-# The new user should not be able to select anymore.
-run(c2, 'UPDATE test SET x = -66 WHERE y = 66')
-run(c2, 'INSERT INTO test VALUES (66, 66)')
-run(c2, 'DELETE FROM test WHERE y = -66')
-query(c2, 'SELECT * FROM test')
+# # The new user should not be able to select anymore.
+# run(c2, 'UPDATE test SET x = -66 WHERE y = 66')
+# run(c2, 'INSERT INTO test VALUES (66, 66)')
+# run(c2, 'DELETE FROM test WHERE y = -66')
+# query(c2, 'SELECT * FROM test')
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
