database
i have a form with a datagrid listing all my forms and their access rights how can i create a table for storing this ,i have 32 forms now, am setting rights depends on user level, help me to design the table
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sukesh MarlaPosted Sep 1, 2012, 6:15 AM
Create A table Called Tbloptions (OptionId,OptionName,IsActive)
TblUser(UserId,UserName,......)
TblUserRights(UserId,OptionId,IsNew,IsEdit);
Or Else
Create One more Table
Tbloptions (OptionId,OptionName,IsActive)
TblRoles(RoleId,RoleName);
TblRoleRight(RoleId,OptionId,IsNew,IsEdit);
TblUser(UserId,UserName,RoleId,......)
If you have some users whio belongs to same set of rights , assign them same role.
and assign rights to Role instead of assigning to user
Check this is correct answer if it helped.