Changeset: a4c6641aaeac for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a4c6641aaeac Modified Files: sql/test/mapi/Tests/clientinfo-nonadmin.test Branch: Aug2024 Log Message:
Test sys.sessions row permissions interaction with SET ROLE diffs (33 lines): diff --git a/sql/test/mapi/Tests/clientinfo-nonadmin.test b/sql/test/mapi/Tests/clientinfo-nonadmin.test --- a/sql/test/mapi/Tests/clientinfo-nonadmin.test +++ b/sql/test/mapi/Tests/clientinfo-nonadmin.test @@ -60,3 +60,29 @@ 3 user 2b +# Having the same role does not mean you can see each others details + +statement ok +CREATE ROLE common + +statement ok +GRANT common TO user1 + +statement ok +GRANT common TO user2 + +@connection(id=user1) +statement ok +SET ROLE common + +@connection(id=user2a) +statement ok +SET ROLE common + +# no user2! +@connection(id=user1) +query IT rowsort +SELECT sessionid, remark FROM sys.sessions +---- +1 +user 1 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
