aboutsummaryrefslogblamecommitdiffstats
path: root/test/permissions.sql
blob: a848a745a7ce03482d58d36449afba53ded319a7 (plain) (tree) 
8d018d9

























1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
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;