1.1 --- a/setup/postgres/psql_create_database.sql Tue Dec 26 19:45:31 2017 +0100 1.2 +++ b/setup/postgres/psql_create_database.sql Sat Dec 30 20:35:23 2017 +0100 1.3 @@ -1,9 +1,5 @@ 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 +-- Create a database owner role, which is also a privileged user 1.11 +create user lightpit_dbo with password 'lpit_dbo_changeme'; 1.12 1.13 -- Create the actual (unprivileged) database user 1.14 create user lightpit_user with password 'lpit_user_changeme';