Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.
You can log in there with your existing account of this site.
The content remains free of charge.
4.2. Installation Link database
4.2.4. Create database
scheme and users for ERP (exemplified by MSSQL)
|
|
---|---|
Prev | Next |
In the following the creation of the database scheme and the user "erpuser" is explained:[70]
Create the Database: Right-click ‘Databases’ -> ‘New Database’
-> The dialog box New database opens. Enter the desired Database name and click on „Add“ and then on OK.
Select the created database and click on New Query.
Now you need the database script for creation of the database structure from the installation CD (tools\databases\MSSQL\erp_install_mssql.sql).
Copy the content into the empty query field using Copy&Paste and in addition, at the beginning, add the following:
USE [datenbankname] GO ...
Now open a new query and create the user "erpuser" by the following script:
As a template, you can use the script plinkdb_reuse.sql (under tools\databases\MSSQL).
Finally you have to allocate the desired rights for the user "erpuser": Right-click on „erpuser“ -> "Properties".
In the dialog box "Database User - <user_name>" define the desired memberships for the respective user and finally confirm with OK.
[70] Here exemplified by MSSQL Use the provided script for your database type (see Section 4.2.4.1, “Installations script ”) and adjust it accordingly.