I'm doing a new application and need to be clear in my mind the options available in creating users,roles and permissions and assigning these to the users.
The application will be aa VB 2008 windows forms app with sql 2005 as the backend.
I'm planning to create a sql server login that will be used thrpught the application -and it will have the sysadmin role.
Then I will create tables for users,roles and permissions.
The permissions will be tagged to particular forms -for example Form1 has a Buttons to Add,Save,Delete and close.
Each of these buttons will be flagged in the permissions table together will all other controls in the applocation and if a user has permission to Save then the Save button will be active together with the other required controls.
Otherwise teh control is disabled.
I find this very manual and difficult to maintain.
Is there a more elegant way of doing this???
Thanks in advance.