How to give to users rights

Here Its
tbl_CredentialMaster
id Credential
1 View
2 Add
3 Edit
4 Delete
5 All

tbl_roleMaster

id RoleId RoleDesc
1 1 Admin
2 2 Golden user
3 3 Silver user
4 4 Customer User

tbl_ModuleMaster
id ModuleId ModuleName
1 1 ItemMaster
2 2 Gld_CustomerMaster
3 3 Slver_CustomerMaster

tbl_RolesAndCredentials

id RoleID ModulId AccessId
1     1     1     5
2     1     2     5
3     2     1     5
4     2     2     5
5     3     1     5
6     3     3     5
7     4     1     1

Now Your Roles&Credential database Design is ready
you have to create UI and Assign accordingly

Now When user Loged In pass the roleId and moduleId
and get the Assinged Credentials and Sore in session
On that Base You Can restrict User.


Thanks.