Deleting Users
-
Select Setup > Users. The User Manager appears.
-
Select the user to delete
-
From the User menu, select Delete. The Confirm window appears.
-
Select Yes to delete the user and continue.
-
Select Yes to all to delete all selected users.
-
Select No to cancel this deletion and continue.
-
Select No to all to cancel the operation.
-
NOTE: A user record can be permanently deleted ONLY when that user has never created or modified any records in the EnergyCAP database (a 'view-only' user, for example) . Once the user ID appears in a record, SQL will roll back the delete transaction causing the username to re-appear in the list of Users. This is because EnergyCAP does not permit a record (a bill or account record, for example), that references a non-existent user ID as the ‘created by’ or ‘last modified by’ user. SQL does not allow this “broken reference link.”
What can be done is that the inactive user’s login name and password can be altered so that all 'deleted' (inactive) users fall at the bottom of the User list and can never be used as a login. For example, add an “x” or "z" prefix to the user name (x-John Smith) and then change the password. All of the 'x-' names will appear at the bottom of the User list, and the record of all database actions (bills created or modified by John Smith, for example) will remain for future reference.
