Design a Project
- Last UpdatedJun 28, 2022
- 2 minute read
Design a Project gives an example of how a simple project could be designed. It describes what databases will be required, and what users and teams. It also describes how the databases should be added to the Multiple DataBases (MDBs).
Databases
The project will contain the following databases:
-
A pipework catalogue (PIPE, PIPE-N, PIPE-S).
-
A steelwork catalogue (STEEL, STEEL-N, STEEL-S).
-
Four Model databases, for pipework and steelwork in two areas of the Plant, North and South.
-
A Draft database (Draft).
-
An Isodraft database (ISO).
-
A Properties database (PROP).
Teams and Users
This will mean creating the following teams and users:
|
Team |
User/Password |
Owning the database(s) |
Type |
|---|---|---|---|
|
CATA |
CATA/CATA |
CATA/PIPE CATA/STEEL |
CATA |
|
PIPE-N |
PIPE-N/PIPE-N |
PIPE-N/PIPE-N |
DESI |
|
PIPE-S |
PIPE-S/PIPE-S |
PIPE-S/PIPE-S |
DESI |
|
STEELN |
STEELN/STEELN |
STEELN/STEELN |
DESI |
|
STEELS |
STEELS/STEELS |
STEELS/STEELS |
DESI |
|
DRAFT |
DRAFT/DRAFT |
DRAFT/DRAFT |
PADD |
|
ISO |
ISO/ISO |
||
|
ADMIN |
ADMIN/ADMIN |
ADMIN/DICT ADMIN/PROP |
DICT PROP |
In addition, the following teams and users will be needed for the administrative functions within the constructor modules.
For example, access to the Draft Administrator application is only available to members of the Draft Administration team.
|
Team |
User/Password |
|---|---|
|
PARAGONADMIN |
PARADM/PARADM |
|
DESADMIN |
DESADM/DESADM |
|
DRAFTADMIN |
DRAADM/DRAADM |
|
ISOADMIN |
ISOADM/ISOADM |
MDBs
User CATA
CATA will have write access to the databases CATA/PIPE and CATA/STEEL. CATA will not need access to any other databases, so the list of databases in the MDB CATA will look like this:
CATA/PIPE
CATA/STEEL
User PIPE-N
PIPE-N will have write access to the database PIPE-N/PIPE-N. This user will need read access to the following databases:
The pipework Catalogue CATA/PIPE
The steelwork Model database STEELN/STEELN, for clash checking.
The list of databases in the MDB PIPE-N will look like this:
PIPE-N/PIPE-N
CATA/PIPE
STEELN/STEELN
Users PIPE-S, STEELN, STEELS
These users will have MDBs similar to PIPE-N, with corresponding access rights to the appropriate Model databases.
User Draft
User Draft will have write access to the DRAFT/DRAFT database. This user will need read access to all the Model databases and Catalogue databases, and so the list of databases in the MDB Draft will look like this:
DRAFT/DRAFT
PIPE-N/PIPE-N
PIPE-S/PIPE-S
STEELN/STEELN
STEELS/STEELS
CATA/PIPE
CATA/STEEL
User ISO
User ISO will need read access to all the Model databases and Catalogue databases, and so the list of databases in the MDB ISO will look like this:
PIPE-N/PIPE-N
PIPE-S/PIPE-S
CATA/PIPE
CATA/STEEL