powered by CADENAS

Manual

Manual

4.12.1.4.  Create database user on the side of PARTsolutions via PARTadmin (dialog "Database user")

Database users are saved in the configuration file plinkusers.cfg.

In order to locally add users in PARTsolutions, do the following:

  1. Under Category, select User.

  2. In the list field, select the used database type. (Here in the following figure exemplarily MS-SQL)

    Click on Login.

    Log in to the database

    Log in to the database

  3. The login window Database login… appears.

    In the list field under Database, select the desired database, to which you want to connect.

    Log in with administrative rights, otherwise you cannot perform changes.

    Default Admin-Login at PLINKDB database:

    • User: sa

    • Password: The respective password had been created at the creation of database.

    Confirm with OK.

  4. After successful login the button Load is active. After a click on the button all already created database users are displayed.

    Created database users

    Created database users

  5. Dialog area Database user -> button Create locally

    Using this command means that the user displayed in the Database user window is collected in PARTsolutions. The corresponding user then shows up in the User window. He is also taken over into the plinkusers.cfg configuration file.

    $CADENAS_USER/plinkusers.cfg:

    [erpuser]
    GROUPS=
    GROUPORDER="DUMMY","LOC1","LOC2","LOC3","LOCRED1","LOCRED2",...

    [Note] Note

    When using this method first the user is created in the database and afterwards in the configuration file plinkusers.cfg. In this way a functioning configuration is ensured in any case.

Delete database user

There are two Delete buttons. Please regard the difference!

  • User-Role assignment -> Delete

    -> The user is deleted from the configuration file plinkusers.cfg.

  • Database user -> Delete

    -> The user is deleted from the database.

Also see Section 4.12.1.3, “Create users on the side of PARTsolutions via PARTadmin (dialog User-Role assignment) / plinkusers.cfg -> Block <user name>”.