1.1 --- a/setup/01_create_database.sql Sun Nov 26 16:20:38 2017 +0100
1.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000
1.3 @@ -1,23 +0,0 @@
1.4 --- Create a database owner role, which has no login permissions.
1.5 --- You can either:
1.6 --- 1) login as default user and switch the user
1.7 --- 2) decide to override this decision and give login permissions
1.8 --- 3) use your superuser of choice to manage the database (not recommended!)
1.9 -create role lightpit_dbo with password 'lpit_dbo_changeme';
1.10 -
1.11 --- Create the actual (unprivileged) database user
1.12 -create user lightpit_user with password 'lpit_user_changeme';
1.13 -
1.14 --- Create the LightPIT schema
1.15 -create schema lightpit authorization lightpit_dbo;
1.16 -
1.17 -
1.18 --- Grant basic privileges to user (the granting user must be the dbo)
1.19 -alter default privileges for role lightpit_dbo in schema lightpit
1.20 - grant select, insert, update, delete on tables to lightpit_user;
1.21 -alter default privileges for role lightpit_dbo in schema lightpit
1.22 - grant usage, select on sequences to lightpit_user;
1.23 -alter default privileges for role lightpit_dbo in schema lightpit
1.24 - grant execute on functions to lightpit_user;
1.25 -alter default privileges for role lightpit_dbo in schema lightpit
1.26 - grant usage on types to lightpit_user;
