Changeset: 3c15d070d210 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3c15d070d210 Modified Files: sql/test/Users/Tests/user_default_role.test Branch: Jun2023 Log Message:
Tests if sysadmin user can CREATE USR with DEFAULT ROLE diffs (30 lines): diff --git a/sql/test/Users/Tests/user_default_role.test b/sql/test/Users/Tests/user_default_role.test --- a/sql/test/Users/Tests/user_default_role.test +++ b/sql/test/Users/Tests/user_default_role.test @@ -53,3 +53,26 @@ foo statement ok set role bartender +-- test if a sysadmin can do the same +statement ok +create user andy with password 'andy' name 'andy' default role sysadmin + +@connection(id=andy, username=andy, password=andy) +statement ok +create user bob with password 'bob' name 'bob' default role bartender + +@connection(id=bob, username=bob, password=bob) +query T nosort +select current_role +---- +bartender + +-- check if the new user has granted the roles +@connection(id=bob) +statement ok +set role bob + +@connection(id=bob) +statement ok +set role bartender + _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
