Deleting Users from the Portal

Deleting Users from the Portal

For historical and auditing purposes, we recommend deactivating users rather than deleting them.

  1. Navigate to User Administration under the Administration menu.
  2. Tap Edit next to the user's name.
  3. Uncheck the Active checkbox.
  4. Tap Update User.

The page may not refresh, but the change is saved.

Delete a User (if Required)

If your portal administrator determines that a user must be permanently deleted:

  1. Back up your PanatrackerGP database.
  2. Run the below script to alter the SQL constraints against your PanatrackerGP database.
  3. Execute the following SQL statement, replacing the example username with the actual username:

      sql DELETE FROM PanatrackerGP.dbo.[User] WHERE UserName = 'bugsbunny'

  1. Refresh the User Administration page to verify the user is removed.

Script to alter user constraints

  1. ALTER TABLE [dbo].[UserSecurityRole]
  2. DROP CONSTRAINT [FK_UserSecurityRole_User]
  3. GO
  4. ALTER TABLE [dbo].[UserSecurityRole]
  5. ADD  CONSTRAINT [FK_UserSecurityRole_User]
  6. FOREIGN KEY ([UserOid])
  7. REFERENCES [dbo].[User] ( [Oid] )
  8. ON DELETE CASCADE
  9. GO

    • Related Articles

    • How is the authentication of hand held devices and users handled?

      PanatrackerGP uses its own authentication system stored in the Panatrack database — Windows Active Directory credentials are not required on the devices. Web Portal Authentication The PanatrackerGP web portal authenticates users through its internal ...

    • How to add a user to the PanatrackerGP portal and handheld

      New users must be created in the PanatrackerGP portal before they can access the system on handheld devices. Follow these steps to create a user account and verify handheld access. Create a new user Sign into the PanatrackerGP portal as an ...

    • Device Setup

      The Device Setup page allows you to manage all handheld devices that connect to your PanatrackerGP portal. Access Device Setup from the Panatracker portal under Configure > Device Setup. Device Setup Features On the Device Setup page, the current ...

    • How to find the details of an error in the PanatrackerGP portal.

      When you receive an error on the handheld, detailed error information is available on the corresponding transaction page in the PanatrackerGP portal. Find the Portal Address If you don't know your portal address: From the Main Menu in the handheld ...

    • Why does the web portal show the same IP address for my handhelds?

      Cause When multiple handhelds show the same IP address in the PanatrackerGP web portal, they are likely connecting through a Network Address Translation (NAT) device or proxy server. Common scenarios include: Handhelds connecting through a wireless ...