 |
 |
 |
 |
Key Benefits
- Clearly arranged list of all users and privileges
- Ability to assign privileges to one or more users
- Ease of use for granting and revoking privileges
- Short reaction time in case of access right problems in production environments.
In huge productive systems like ERP often times several hundred database users are active at the same time. To manage the access privileges efficiently, database management systems usually offer user groups or role definitions. These logical units have the corresponding access rights. Having this system users just need to be assigned to a group to inherit the privileges. If this opportunity is missing any single user has to be configured and management costs are significantly higher.
The database management server MySQL in the new version, still does not offer user groups or roles. The user management for AlligatorSQL MySQL Edition shows all database users in an overview list. Access rights can be granted or revoked. Changes can be assigned to only one user or all selected rows of the list.
