Changeset: 64ec17723b6e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/64ec17723b6e Added Files: sql/test/mergetables/Tests/mergetable-perms-base.test sql/test/mergetables/Tests/mergetable-select-perms.reqtests sql/test/mergetables/Tests/mergetable-select-perms.test Modified Files: sql/test/mergetables/Tests/All Branch: default Log Message:
Adds test for select perms on mergetable diffs (89 lines): diff --git a/sql/test/mergetables/Tests/All b/sql/test/mergetables/Tests/All --- a/sql/test/mergetables/Tests/All +++ b/sql/test/mergetables/Tests/All @@ -38,3 +38,6 @@ merge-tables-limitations mergetable00 mergetable01 + +mergetable-perms-base +mergetable-select-perms diff --git a/sql/test/mergetables/Tests/mergetable-perms-base.test b/sql/test/mergetables/Tests/mergetable-perms-base.test new file mode 100644 --- /dev/null +++ b/sql/test/mergetables/Tests/mergetable-perms-base.test @@ -0,0 +1,20 @@ +statement ok +create table part1 (n int, m text) + +statement ok +insert into part1 values (1, 'alice') + +statement ok +create table part2 (n int, m text) + +statement ok +insert into part2 values (2, 'bob') + +statement ok +create merge table allparts (n int, m text) + +statement ok +alter table allparts add table part1 + +statement ok +alter table allparts add table part2 diff --git a/sql/test/mergetables/Tests/mergetable-select-perms.reqtests b/sql/test/mergetables/Tests/mergetable-select-perms.reqtests new file mode 100644 --- /dev/null +++ b/sql/test/mergetables/Tests/mergetable-select-perms.reqtests @@ -0,0 +1,1 @@ +mergetable-perms-base diff --git a/sql/test/mergetables/Tests/mergetable-select-perms.test b/sql/test/mergetables/Tests/mergetable-select-perms.test new file mode 100644 --- /dev/null +++ b/sql/test/mergetables/Tests/mergetable-select-perms.test @@ -0,0 +1,43 @@ +-- select through individual user perms + +statement ok +create user kate with password '123kate' name 'Kate' schema sys + +@connection(id=tc, username=kate, password=123kate) +statement error 42000!SELECT: access denied for kate to table 'sys.allparts' +select * from allparts + +statement ok +grant select on allparts to kate + +@connection(id=tc, username=kate, password=123kate) +query IT rowsort +select * from allparts +---- +1 +alice +2 +bob + +-- select through role + +statement ok +create role reader + +statement ok +grant select on allparts to reader + +statement ok +create user tom with password '123tom' name 'Tom' schema sys + +statement ok +alter user tom default role reader + +@connection(id=tc, username=tom, password=123tom) +query IT rowsort +select * from allparts +---- +1 +alice +2 +bob _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
