diff options
author | sadbeast <sadbeast@sadbeast.com> | 2024-06-23 15:36:59 -0700 |
---|---|---|
committer | sadbeast <sadbeast@sadbeast.com> | 2024-07-13 21:58:23 -0700 |
commit | 8d018d996c1eddb882dc64ebbd228bb0135944f3 (patch) | |
tree | d01956546a77dbae33357c9a5d174f511ac9b282 /test/permissions.sql | |
download | teamdraft-8d018d996c1eddb882dc64ebbd228bb0135944f3.tar.gz teamdraft-8d018d996c1eddb882dc64ebbd228bb0135944f3.tar.bz2 |
Diffstat (limited to 'test/permissions.sql')
-rw-r--r-- | test/permissions.sql | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/test/permissions.sql b/test/permissions.sql new file mode 100644 index 0000000..a848a74 --- /dev/null +++ b/test/permissions.sql @@ -0,0 +1,25 @@ +/* CREATE EXTENSION IF NOT EXISTS pgtap; */ +BEGIN; +SELECT plan(9); + +SELECT has_group('dml'); +SELECT has_group('ddl'); +SELECT has_group('read_only'); + +SELECT has_user('teamdraft'); +SELECT database_privs_are( + 'teamdraft', 'teamdraft', ARRAY['CONNECT', 'TEMPORARY', 'CREATE'] +); + +SELECT has_user('teamdraft_website'); +SELECT database_privs_are( + 'teamdraft', 'teamdraft_website', ARRAY['CONNECT', 'TEMPORARY'] +); + +SELECT has_user('teamdraft_ro'); +SELECT database_privs_are( + 'teamdraft', 'teamdraft_ro', ARRAY['CONNECT', 'TEMPORARY'] +); + +SELECT * FROM finish(); +ROLLBACK; |