User Account Section Access Manager
4 posts by 3 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: March 5, 2015 (RSS)
By markr - February 24, 2015
Here's a wish list item...
With many users and changing section access it is necessary to keep track of who has access to what. Every year I have large staff turnover and it is more than a notion to hunt down and change the section access. Need to use a secondary source to keep track.
Would be very helpful to have a list of sections and ability to see all those users that have access thereto.
By claire - February 25, 2015
Hi there
I think the CSV Export plugin may do this for you. I'll take a look and see if it'll work.
Claire Ryan
interactivetools.com
Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
By claire - February 25, 2015
Okay, just had a quick chat with another dev here - we could modify the CSV export plugin to handle this, but it won't work as is.
I'll refer this to Dave for possible inclusion in a future CMSB release, but if you need something sooner for this problem, just let us know.
Claire Ryan
interactivetools.com
Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
By Dave - March 5, 2015
Hi Markr,
You can generate a list of sections and the users who have access to this with this MySQL query:
SELECT al.tableName, a.username, a.email, al.accessLevel, al.maxRecords FROM cms__accesslist al
JOIN cms_accounts a ON a.num = al.userNum
WHERE al.accessLevel > 0
ORDER BY tableName, username
Just replace "cms_" with your MySQL table prefix if you've set it to something else.
And you could run that with one of these plugins:
- http://www.interactivetools.com/add-ons/detail.php?MySQL-Console-1011
- http://www.interactivetools.com/add-ons/detail.php?Report-Builder-1043
Hope that helps!
interactivetools.com