hi guys
i want ur help in implementing my logic. I want to make a simple user rights program. my logic is to first Create Roles, Assign the Roles Rights to Add / Edit etc... and later on Assign the Roles to indvidual users as per theire positions.
Here are the Table Structures along with Sample Data. I am not able to figure out how would i store the information that which role has got what rights.... infact i have posted this question earlier also but didnt get a satisfying reply, so this time i m to the point....
Login_Details Table:
+++++++++++++++++++
L_Tran_No Login_ID Login_Name Password IsActive
=============================================================
1 admin Administrator admin 1
2 sam sam sam 1
Parent_Menu_Master Table:
+++++++++++++++++++++++++
P_Menu_Id P_Menu_Name IsActive CanAccess
=================================================================
1 Daily Transactions 1 0
2 Administration 0 0
3 Reports 1 0
4 Utilities 0 0
Child_Menu_Master Table:
++++++++++++++++++++++++
C_Menu_Id C_Menu_Name C_IsACtive C_CanAccess
=================================================================
1 Collection Sheet 1 0
1 Audit Transactions 1 0
2 Company Master 1 0
2 Login Details 1 0
2 MemberShip Plans 1 0
there would be max two ROLES i.e. Administrators and Operators. As the name suggests the Administrators will have all the menu options enabled where as the Operators will have few. Let me be more precise my application Startup Form has got Four Command Buttons called
Admin, Transactions, Reports & Utilities. each of these buttons have got an MDI Form with Menu's in it, So my Parent_Menu_Master contains the Four options specified above and the Child_Menu_Master contains sub menus.
hope this is more precise and clear
gazal
i want ur help in implementing my logic. I want to make a simple user rights program. my logic is to first Create Roles, Assign the Roles Rights to Add / Edit etc... and later on Assign the Roles to indvidual users as per theire positions.
Here are the Table Structures along with Sample Data. I am not able to figure out how would i store the information that which role has got what rights.... infact i have posted this question earlier also but didnt get a satisfying reply, so this time i m to the point....
Login_Details Table:
+++++++++++++++++++
L_Tran_No Login_ID Login_Name Password IsActive
=============================================================
1 admin Administrator admin 1
2 sam sam sam 1
Parent_Menu_Master Table:
+++++++++++++++++++++++++
P_Menu_Id P_Menu_Name IsActive CanAccess
=================================================================
1 Daily Transactions 1 0
2 Administration 0 0
3 Reports 1 0
4 Utilities 0 0
Child_Menu_Master Table:
++++++++++++++++++++++++
C_Menu_Id C_Menu_Name C_IsACtive C_CanAccess
=================================================================
1 Collection Sheet 1 0
1 Audit Transactions 1 0
2 Company Master 1 0
2 Login Details 1 0
2 MemberShip Plans 1 0
there would be max two ROLES i.e. Administrators and Operators. As the name suggests the Administrators will have all the menu options enabled where as the Operators will have few. Let me be more precise my application Startup Form has got Four Command Buttons called
Admin, Transactions, Reports & Utilities. each of these buttons have got an MDI Form with Menu's in it, So my Parent_Menu_Master contains the Four options specified above and the Child_Menu_Master contains sub menus.
hope this is more precise and clear
gazal