setup/postgres/psql_create_database.sql

changeset 16
4e0998805276
parent 5
131903fc16b8
     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';

mercurial