blob: a848a745a7ce03482d58d36449afba53ded319a7 (
plain) (
blame)
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;
|