User Account Section Access Manager

4 posts by 3 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: March 5, 2015   (RSS)

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: 

Hope that helps!

Dave Edis - Senior Developer
interactivetools.com