Mercurial > hg > LightPIT / changeset

     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/setup/01_create_database.sql	Thu Apr 06 17:44:17 2017 +0200
     1.3 @@ -0,0 +1,23 @@
     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;