CREATE USER frankeerp WITH PASSWORD 'FrankeERP';
GRANT ALL ON TABLE workorder TO frankeerp;
GRANT ALL ON TABLE workdata TO frankeerp;
| ERP | proALPHA |
| share data type | from file (XML) |
| server | fkt20g.fa.franke.world (10.100.145.20) |
| path | ~/frankeerp/FWK |
| credentials | frankeerp:FrankeERP |
FPL - Poland Plant
| ERP | JetCAM |
| share data type | from file (FSM) |
| server | fkt20g.fa.franke.world (10.100.145.20) |
| path | ~/frankeerp/FPL |
| credentials | frankeerp:FrankeERP |
| ERP | PBS |
| share data type | database |
| server | 10.100.145.20 |
| role | frankeerp:FrankeERP |
| database | andon_FPL |
| schemas | workorder,workdata |
| ERP | PBS |
| share data type | database |
| server | 10.60.1.21 |
| role | frankeerp:FrankeERP |
| database | andon_FHP |
| schemas | workorder,workdata |
| ERP | PBS |
| share data type | database |
| server | 10.164.1.88 |
| role | frankeerp:FrankeERP |
| database | andon_FNO |
| schemas | workorder,workdata |
| ERP | PBS |
| share data type | database |
| server | 10.164.1.88 |
| role | frankeerp:FrankeERP |
| database | andon_FPK |
| schemas | workorder,workdata |
| ERP | SAGE |
| share data type | database |
| server | 10.184.1.36 |
| role | frankeerp:FrankeERP |
| database | andon_FSA |
| schemas | workorder,workdata |
| ERP | Local |
| share data type | database |
| server | 10.60.1.21 |
| role | frankeerp:FrankeERP |
| database | andon_FFB |
| schemas | workorder,workdata |
| ERP | PBS |
| share data type | database |
| server | 10.60.1.21 |
| role | frankeerp:FrankeERP |
| database | andon_FKC |
| schemas | workorder,workdata |