user management-role using mysql

[aniltc]

can any one help me to create a user management and role table in mysql.

what I need, I would like to apply add/edit/delete/view permisson for a login users as well as group level users.


group level users are architect,enigners etc (these are different types of users)
these users are also login users ( I mean they are registered) . so while acessing some pages in my site i should give a add/edit/delete/view permisson for login users as well as groep level users. How can i achieve this ? how the table structure looks? please help me


Thanks

[PHPycho]

Simple solution makes a use of following tables:

---------------------------------------------------------
users
---------------------------------------------------------
id | group_id | username | email | password | status ....
---------------------------------------------------------

----------------------------------------------
groups
----------------------------------------------
id | group_name
----------------------------------------------

--------------------------------------------------------------------
group_permissions
--------------------------------------------------------------------
id | group_id | page_key | can_edit | can_delete | can_view | can_add
--------------------------------------------------------------------

Note: page_key are the values of the pages where you want to check the permissions.
can_* are the boolean values ie they can have 0 or 1 values.

In PHP you can check like this:

if (hasPermission($page_key, $action){
    //perform action ie can_*
}else{
    //redirect to access denied page
} 

Hope this helps.