TPRestoreSupervisor utility program
Prev Chapter 31. Create or restore the Supervisor user role Next
TPRestoreSupervisor utility program

© Tillypad, 2008-2015

TPRestoreSupervisor utility program

TPRestoreSupervisor.exe

Figure 31.1. TPRestoreSupervisor utility program window


The utility program displays two groups of fields: Connect to MSSQL Server and Supervisor logon properties.

  • Connect to MSSQL Server group of fields:

    • Server is the network name of the database server. This is a required field.

    • Database indicates the name of the database. This is a required field.

    • Login is the username that is used to connect to the database. This is a required field.

    • Password is the password that is used to connect to the database. This is a required field.

  • Supervisor logon properties group of fields:

    • Login is the username (login) that will be used by the user with unlimited rights (the supervisor). This is a required field.

    • Password designates the password of the user with unlimited rights (the supervisor). This is a required field.

    • Confirm password is a field for confirming the password specified in the Password field. This is a required field.

Pressing OK will store the entered data in the database:

  • The previously deleted SUPERVISOR user role will be restored from the Recycle bin. If no supervisor existed previously, a new SUPERVISOR user role is created.

    The SUPERVISOR user role is assigned the SUPERVISOR security level. All security levels are deleted from the access settings for this user role.

  • The previously deleted SUPERVISOR employee will be restored from the Recycle bin. If no supervisor existed previously, a new SUPERVISOR employee is created.

    The Inactive attribute is set to No. The Username and Password attributes are assigned to the entered values.

  • The previously deleted SUPERVISOR security level will be restored from the Recycle bin. If no supervisor existed previously, a new SUPERVISOR security level is created.

    The Owner attribute is assigned the SUPERVISOR user role.

    All user roles are deleted from the access settings for this security level.

Selecting Cancel stops the utility program without saving any changes to the database.