diff options
Diffstat (limited to 'util/sql/superuser_init.sql')
-rw-r--r-- | util/sql/superuser_init.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/util/sql/superuser_init.sql b/util/sql/superuser_init.sql new file mode 100644 index 00000000..145ff30e --- /dev/null +++ b/util/sql/superuser_init.sql @@ -0,0 +1,13 @@ +-- This script should be run before all other scripts and as a PostgreSQL +-- superuser It will create the VNDB database and required users. +-- All other SQL scripts should be run by the 'vndb' user. + +-- In order to "activate" a user, i.e. to allow login, you need to manually run +-- the following for each user you want to activate: +-- ALTER ROLE rolename LOGIN UNENCRYPTED PASSWORD 'password'; + +CREATE ROLE vndb; +CREATE DATABASE vndb OWNER vndb; + +-- The website +CREATE ROLE vndb_site; |