|Project:||Menu per Role|
Here's my usage scenario for this module: I have site with two roles, "admin" and "manager". The admin, of course, has nearly all authorization as user 1 to add or modify 100 pages on the website. However, the manager role has access to edit and delete only 10 specific pages or sections of the website- along with only 10 corresponding items in a custom menu.
The problem arises when I install the module and all menu items have no restrictions by default. Makes sense. But now I have to edit every menu item in Primary, Secondary, and Navigation links and change their role access. The goal is for the "manager" role to only deal with her own menu and not see anything esle.
Question: To aviod waisting precious time editing the role access on every menu item, where in the database can the role access values be found?
I'm thinking that I could come up (ask someone that knows) with a query that could change all menu items in the database. Something along the lines of:
For each 'field' in 'table' where 'field' = 'authenticated', update 'field' = 'admin'
This is probably oversimplification since I'm not a Mysql expert, but it may be a step in the right direction.
Your help and advice is greatly appreciated!