I am trying to model a User Authentication module for a MS SQL Server database that will be the back end to a Delphi UI Application. Basically, I want to have user accounts where the user belongs to only one group. A group can have "n" number of rights.
I also want to add password history to the database, as the user will be required to change their password based on a application setting (example, every 90 days).
I also want to log an event for each time a user logs in and out. I may extend this to additional events in the future.
Below you will find my first crack at it. Please let me know any suggestions to improve upon it, as this is my first time doing this.
Do you see any need for additional attributes for role-based security and constraints for the password rules/expiration periods?