I want to know and learn what is the concept and underlying technique behind creating a role based menu in an erp application. We have all seen it work. But I don't knwo how to implement it. For example take an Institute management System. It can have users
belonging to three different roles, namely admin, faculty and students. When a user logs in by providing username and password he is presented with an appropriate menu depending on what role he has been assigned. For each role there is a different
menu with admin having the maximum privelege and access to maximum resources and facilities and student having the least.
I would want to know how to create such a system. I want to know what are the tables I need to create and what data they should hold in what format and how to load different menus depending on the roles assigned to the user. It is all database centric. That
is very obvious. But I can't fathom how to approach the task. Any reference or worked out example would be of massive help. Explanations with reference to the above mentioned institute management system would be of much help to me and massively appreciated.
Look forward to receiving some replies and help on this matter.
Many Thanks in advance.
There are more wonders in this world of ours than you can wonder.....
Thank you for this link but this is not quite what I am looking for. It is suggesting the use of sitemap and bind it to the menu control. I am looking for something that involves database. For example let's assume that there is a master table in the database
called roles_mst which has the following data ---
role_name role_id
------------------------------
admin 1
faculty 2
student 3
This means that users registered with the application can belong to any one of these three roles. For eg let there be a table called users_info containing data like --
Now when the user logs in by providing username and password the application will check his role and accordingly present him with the subsequent menu, which will be different for all three roles. How to do this?
Thanks.
There are more wonders in this world of ours than you can wonder.....
PGChoudhury
Member
11 Points
131 Posts
Role Based Menu for ERP Applications ---
May 06, 2012 07:19 PM|LINK
I want to know and learn what is the concept and underlying technique behind creating a role based menu in an erp application. We have all seen it work. But I don't knwo how to implement it. For example take an Institute management System. It can have users belonging to three different roles, namely admin, faculty and students. When a user logs in by providing username and password he is presented with an appropriate menu depending on what role he has been assigned. For each role there is a different menu with admin having the maximum privelege and access to maximum resources and facilities and student having the least.
I would want to know how to create such a system. I want to know what are the tables I need to create and what data they should hold in what format and how to load different menus depending on the roles assigned to the user. It is all database centric. That is very obvious. But I can't fathom how to approach the task. Any reference or worked out example would be of massive help. Explanations with reference to the above mentioned institute management system would be of much help to me and massively appreciated.
Look forward to receiving some replies and help on this matter.
Many Thanks in advance.
Gaspard
Contributor
2066 Points
416 Posts
Re: Role Based Menu for ERP Applications ---
May 07, 2012 02:06 PM|LINK
This thread may be of interest
http://stackoverflow.com/questions/4939031/can-i-hide-show-aspmenu-items-based-on-role
Regards
PGChoudhury
Member
11 Points
131 Posts
Re: Role Based Menu for ERP Applications ---
May 07, 2012 03:57 PM|LINK
Thank you for this link but this is not quite what I am looking for. It is suggesting the use of sitemap and bind it to the menu control. I am looking for something that involves database. For example let's assume that there is a master table in the database called roles_mst which has the following data ---
role_name role_id
------------------------------
admin 1
faculty 2
student 3
This means that users registered with the application can belong to any one of these three roles. For eg let there be a table called users_info containing data like --
user_id user_fname user_username user_pwd user_role.............................................
------------------------------------------------------------------------------------------------------------------------------------------------------
1 John john4ever xyz 2
2 Lucy lucy lucy2121 1
3 Max Maxlove qweasd007 3
and so on
Now when the user logs in by providing username and password the application will check his role and accordingly present him with the subsequent menu, which will be different for all three roles. How to do this?
Thanks.
PGChoudhury
Member
11 Points
131 Posts
Re: Role Based Menu for ERP Applications ---
May 10, 2012 07:06 AM|LINK
Someone help me please.
Thanks.