Changeset: 5d1f94b547f9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5d1f94b547f9
Modified Files:
sql/test/Users/Tests/function_privs.SQL.py
sql/test/Users/Tests/role.SQL.py
sql/test/Users/Tests/unknown_user.SQL.py
Branch: default
Log Message:
On this branch, this outputs are expected
diffs (46 lines):
diff --git a/sql/test/Users/Tests/function_privs.SQL.py
b/sql/test/Users/Tests/function_privs.SQL.py
--- a/sql/test/Users/Tests/function_privs.SQL.py
+++ b/sql/test/Users/Tests/function_privs.SQL.py
@@ -136,12 +136,12 @@ with SQLTestCase() as mdb:
tc.execute("UPDATE version SET name = 'test22' WHERE i =
2;").assertFailed(err_code="42000", err_message="UPDATE: insufficient
privileges for user 'my_user2' to update table 'version'")
tc.execute("DELETE FROM version WHERE name =
'test22';").assertFailed(err_code="42000", err_message="DELETE FROM:
insufficient privileges for user 'my_user2' to delete from table 'version'")
tc.execute("SELECT * FROM version;").assertFailed(err_code="42000",
err_message="SELECT: access denied for my_user2 to table 'my_schema.version'")
- tc.execute("SELECT insertversion('test4', 4);").assertSucceeded()
- tc.execute("SELECT * FROM
selectversion();").assertSucceeded().assertDataResultMatch([('test3', 3),
('test4', 4)])
- tc.execute("SELECT updateversion('test3', 33);").assertSucceeded()
- tc.execute("SELECT * FROM
selectversion();").assertSucceeded().assertDataResultMatch([('test3', 33),
('test4', 4)])
- tc.execute("SELECT deleteversion('test3');").assertSucceeded()
- tc.execute("SELECT * FROM
selectversion();").assertSucceeded().assertDataResultMatch([('test4', 4)])
+ tc.execute("SELECT insertversion('test4',
4);").assertFailed(err_code="42000", err_message="INSERT INTO: insufficient
privileges for user 'my_user2' to insert into table 'version'")
+ tc.execute("SELECT * FROM
selectversion();").assertFailed(err_code="42000", err_message="SELECT: access
denied for my_user2 to table 'my_schema.version'")
+ tc.execute("SELECT updateversion('test3',
33);").assertFailed(err_code="42000", err_message="UPDATE: insufficient
privileges for user 'my_user2' to update table 'version'")
+ tc.execute("SELECT * FROM
selectversion();").assertFailed(err_code="42000", err_message="SELECT: access
denied for my_user2 to table 'my_schema.version'")
+ tc.execute("SELECT
deleteversion('test3');").assertFailed(err_code="42000", err_message="DELETE
FROM: insufficient privileges for user 'my_user2' to delete from table
'version'")
+ tc.execute("SELECT * FROM
selectversion();").assertFailed(err_code="42000", err_message="SELECT: access
denied for my_user2 to table 'my_schema.version'")
# and my_user2 cannot create functions to operate on the table
tc.execute("""
create function myselect2() returns table(name varchar(10), i int)
diff --git a/sql/test/Users/Tests/role.SQL.py b/sql/test/Users/Tests/role.SQL.py
--- a/sql/test/Users/Tests/role.SQL.py
+++ b/sql/test/Users/Tests/role.SQL.py
@@ -41,7 +41,7 @@ with SQLTestCase() as tc:
tc.execute("SET ROLE role2;").assertFailed(err_code="42000",
err_message="Role (role2) missing")
tc.connect(username="monetdb", password="monetdb")
- tc.execute("GRANT non_existing_role TO
alice;").assertFailed(err_code="M1M05", err_message="GRANT: Cannot grant ROLE
'non_existing_role' to user 'alice'")
+ tc.execute("GRANT non_existing_role TO
alice;").assertFailed(err_code="M1M05", err_message="GRANT: no such role
'non_existing_role' or grantee 'alice'")
tc.execute("DROP ROLE role1;").assertSucceeded()
tc.execute("DROP ROLE role3;").assertSucceeded()
tc.execute("DROP USER alice;").assertSucceeded()
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
@@ -21,7 +21,7 @@ with SQLTestCase() as tc:
CREATE TABLE t (i INT);
""").assertSucceeded()
- tc.execute("GRANT r1 TO "+usr).assertFailed(err_code="M1M05",
err_message="GRANT: Cannot grant ROLE 'r1' to user '"+usr+"'")
+ tc.execute("GRANT r1 TO "+usr).assertFailed(err_code="M1M05",
err_message="GRANT: no such role 'r1' or grantee '"+usr+"'")
tc.execute("GRANT ALL ON t TO "+usr).assertFailed(err_code="01007",
err_message="GRANT: User/role '"+usr+"' unknown")
tc.execute("GRANT COPY INTO TO "+usr).assertFailed(err_code="01007",
err_message="GRANT: User/role '"+usr+"' unknown")
tc.execute("GRANT COPY FROM TO "+usr).assertFailed(err_code="01007",
err_message="GRANT: User/role '"+usr+"' unknown")
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
