The “User Manager” has been developed by Datacon Data Services and is the main component within the User/Login/Password system. This complete system is included FREE! with any of our custom Access database applications. With the User Manager you can create new users, plus assign roles and permissions, so that users can only view, add, edit and delete information which is a requirement of their job function.
Each company can set their own password rules. Some of the rules which can be configured are:
- Minimum and maximum length of a password.
- Does a password require an upper case character? (e.g. ‘ABC’)
- Does a password require a lower case character? (e.g. ‘abc’)
- Does a password require a number? (e.g. ‘123’)
- How many login attempts before a user gets ‘locked” out?
In addition, the database administrator can create a temporary password for new users and users who are “locked” out.
Each user must log in to the application using their “username” and “password”. The password is encrypted (salted and hashed) and compared to the value in the database for the username submitted. If the password submitted matches the password in the database for that username, then the user is logged in. A user will only be logged in if their current status is “active”. The status of a user can be either “active”, “disabled”, “locked”, or “deleted”. If the user fails to enter the correct password after a specific number of attempts, then that user’s status is changed to “locked” and only the database administrator can reset their status and issue them a new “temporary” password. If the user is using a temporary password, then they are forwarded to an input screen where they must enter a new password, before they will be logged in.
The User Manager provides a great deal of functionality to your application. It is designed for any company that wants to have some control over what actions a user can take within their database application. Normally permissions (which allow a user to perform a certain action) fall within four categories. These four categories are “view”, “add”, “edit”, and “delete”. Some users may have only “view” permissions (read-only), other users might be able to “add” and “edit” records, and a few users will be able to “delete” records. Once you have created your permissions, you can then create your roles. “Roles”, in most cases, are based on job function. You might create an “accounts payable” role, a “customer service” role etc.
Here’s a list of the some of the functionality provided by the User Manager:
- Create a new user from an employee record.
- Create a new user who is not an employee.
- Update the user information from the employee record.
- Send a user an email from the “Manage Users” form.
- Create permissions based on tables and reports.
- Create roles and assign permissions to roles.
- Assign one or more roles to a user.
- Assign individual permissions to a user.
The user manager is fairly easy to use once you understand the concept of roles and permissions. Of course, Datacon also provides you with a complete manual in PDF format that provides detailed instruction on how to use every screen. The user manager, as mentioned, is provided FREE! for you to use as you wish. We also provide customization, if this component does not fulfill your current needs right out of the box. The User Manager is a great way to increase security and ensure that confidential information remains “confidential”. Please contact us if you have any questions about this particular product.