1-- default for superuser is false 2CREATE ROLE regress_test_def_superuser; 3SELECT * FROM pg_authid WHERE rolname = 'regress_test_def_superuser'; 4CREATE ROLE regress_test_superuser WITH SUPERUSER; 5SELECT * FROM pg_authid WHERE rolname = 'regress_test_superuser'; 6ALTER ROLE regress_test_superuser WITH NOSUPERUSER; 7SELECT * FROM pg_authid WHERE rolname = 'regress_test_superuser'; 8ALTER ROLE regress_test_superuser WITH SUPERUSER; 9SELECT * FROM pg_authid WHERE rolname = 'regress_test_superuser'; 10 11-- default for inherit is true 12CREATE ROLE regress_test_def_inherit; 13SELECT * FROM pg_authid WHERE rolname = 'regress_test_def_inherit'; 14CREATE ROLE regress_test_inherit WITH NOINHERIT; 15SELECT * FROM pg_authid WHERE rolname = 'regress_test_inherit'; 16ALTER ROLE regress_test_inherit WITH INHERIT; 17SELECT * FROM pg_authid WHERE rolname = 'regress_test_inherit'; 18ALTER ROLE regress_test_inherit WITH NOINHERIT; 19SELECT * FROM pg_authid WHERE rolname = 'regress_test_inherit'; 20 21-- default for create role is false 22CREATE ROLE regress_test_def_createrole; 23SELECT * FROM pg_authid WHERE rolname = 'regress_test_def_createrole'; 24CREATE ROLE regress_test_createrole WITH CREATEROLE; 25SELECT * FROM pg_authid WHERE rolname = 'regress_test_createrole'; 26ALTER ROLE regress_test_createrole WITH NOCREATEROLE; 27SELECT * FROM pg_authid WHERE rolname = 'regress_test_createrole'; 28ALTER ROLE regress_test_createrole WITH CREATEROLE; 29SELECT * FROM pg_authid WHERE rolname = 'regress_test_createrole'; 30 31-- default for create database is false 32CREATE ROLE regress_test_def_createdb; 33SELECT * FROM pg_authid WHERE rolname = 'regress_test_def_createdb'; 34CREATE ROLE regress_test_createdb WITH CREATEDB; 35SELECT * FROM pg_authid WHERE rolname = 'regress_test_createdb'; 36ALTER ROLE regress_test_createdb WITH NOCREATEDB; 37SELECT * FROM pg_authid WHERE rolname = 'regress_test_createdb'; 38ALTER ROLE regress_test_createdb WITH CREATEDB; 39SELECT * FROM pg_authid WHERE rolname = 'regress_test_createdb'; 40 41-- default for can login is false for role 42CREATE ROLE regress_test_def_role_canlogin; 43SELECT * FROM pg_authid WHERE rolname = 'regress_test_def_role_canlogin'; 44CREATE ROLE regress_test_role_canlogin WITH LOGIN; 45SELECT * FROM pg_authid WHERE rolname = 'regress_test_role_canlogin'; 46ALTER ROLE regress_test_role_canlogin WITH NOLOGIN; 47SELECT * FROM pg_authid WHERE rolname = 'regress_test_role_canlogin'; 48ALTER ROLE regress_test_role_canlogin WITH LOGIN; 49SELECT * FROM pg_authid WHERE rolname = 'regress_test_role_canlogin'; 50 51-- default for can login is true for user 52CREATE USER regress_test_def_user_canlogin; 53SELECT * FROM pg_authid WHERE rolname = 'regress_test_def_user_canlogin'; 54CREATE USER regress_test_user_canlogin WITH NOLOGIN; 55SELECT * FROM pg_authid WHERE rolname = 'regress_test_user_canlogin'; 56ALTER USER regress_test_user_canlogin WITH LOGIN; 57SELECT * FROM pg_authid WHERE rolname = 'regress_test_user_canlogin'; 58ALTER USER regress_test_user_canlogin WITH NOLOGIN; 59SELECT * FROM pg_authid WHERE rolname = 'regress_test_user_canlogin'; 60 61-- default for replication is false 62CREATE ROLE regress_test_def_replication; 63SELECT * FROM pg_authid WHERE rolname = 'regress_test_def_replication'; 64CREATE ROLE regress_test_replication WITH REPLICATION; 65SELECT * FROM pg_authid WHERE rolname = 'regress_test_replication'; 66ALTER ROLE regress_test_replication WITH NOREPLICATION; 67SELECT * FROM pg_authid WHERE rolname = 'regress_test_replication'; 68ALTER ROLE regress_test_replication WITH REPLICATION; 69SELECT * FROM pg_authid WHERE rolname = 'regress_test_replication'; 70 71-- default for bypassrls is false 72CREATE ROLE regress_test_def_bypassrls; 73SELECT * FROM pg_authid WHERE rolname = 'regress_test_def_bypassrls'; 74CREATE ROLE regress_test_bypassrls WITH BYPASSRLS; 75SELECT * FROM pg_authid WHERE rolname = 'regress_test_bypassrls'; 76ALTER ROLE regress_test_bypassrls WITH NOBYPASSRLS; 77SELECT * FROM pg_authid WHERE rolname = 'regress_test_bypassrls'; 78ALTER ROLE regress_test_bypassrls WITH BYPASSRLS; 79SELECT * FROM pg_authid WHERE rolname = 'regress_test_bypassrls'; 80 81-- clean up roles 82DROP ROLE regress_test_def_superuser; 83DROP ROLE regress_test_superuser; 84DROP ROLE regress_test_def_inherit; 85DROP ROLE regress_test_inherit; 86DROP ROLE regress_test_def_createrole; 87DROP ROLE regress_test_createrole; 88DROP ROLE regress_test_def_createdb; 89DROP ROLE regress_test_createdb; 90DROP ROLE regress_test_def_role_canlogin; 91DROP ROLE regress_test_role_canlogin; 92DROP USER regress_test_def_user_canlogin; 93DROP USER regress_test_user_canlogin; 94DROP ROLE regress_test_def_replication; 95DROP ROLE regress_test_replication; 96DROP ROLE regress_test_def_bypassrls; 97DROP ROLE regress_test_bypassrls; 98