diff options
Diffstat (limited to 'business/xtuple/init.sql')
| -rw-r--r-- | business/xtuple/init.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/business/xtuple/init.sql b/business/xtuple/init.sql new file mode 100644 index 0000000000..9076151b68 --- /dev/null +++ b/business/xtuple/init.sql @@ -0,0 +1,21 @@ +-- +-- This script creates the group openmfg and the user mfgadmin +-- + +-- +-- Create the openmfg group +-- +CREATE GROUP openmfg; + +-- +-- Create the mfgadmin user with createdb and createuser +-- permissions. Place the user in the openmfg group and +-- set the password to the default of mfgadmin. +-- +CREATE USER mfgadmin WITH PASSWORD 'mfgadmin' + CREATEDB CREATEUSER + IN GROUP openmfg; +CREATE USER admin WITH PASSWORD 'admin' + CREATEDB CREATEUSER + IN GROUP openmfg; + |