summaryrefslogtreecommitdiff
path: root/business/xtuple/init.sql
blob: 9076151b6871f242220a84674ccb5c03dfcbe456 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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;