Spotter-VM/lxc-apps/seeddms/install/createdb.sql

5 lines
219 B
SQL

CREATE ROLE seeddms NOSUPERUSER NOCREATEDB NOCREATEROLE NOINHERIT LOGIN ENCRYPTED PASSWORD '${SEEDDMS_PWD}';
CREATE DATABASE seeddms;
REVOKE ALL ON DATABASE seeddms FROM public;
ALTER DATABASE seeddms OWNER TO seeddms;