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

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: 

Hope that helps!

Dave Edis - Senior Developer
interactivetools.com