Edit rights
Posted: 2019-05-03 07:12
Is there a quick way to find the number of members who have edit right on a given table. This is a once off so just some SQL should do the trick.
Many thanks
Barry
Many thanks
Barry
A place where AppGini users can exchange ideas and help each other.
https://forums.appgini.com:443/phpbb/
https://forums.appgini.com:443/phpbb/viewtopic.php?f=8&t=2994
Code: Select all
select
membership_grouppermissions.tablename as 'tablename',
count(*) as 'num_editors',
group_concat(membership_users.memberID ORDER BY membership_users.memberID SEPARATOR ', ') as 'editors'
from membership_grouppermissions
inner join membership_groups on membership_grouppermissions.groupID=membership_groups.groupID
inner join membership_users on membership_groups.groupID = membership_users.groupID
where membership_grouppermissions.allowEdit
AND membership_grouppermissions.tablename IN ('YOURTABLE_1', YOURTABLE_2')
group by tablename
order by 1
Code: Select all
AND membership_grouppermissions.tablename IN ('YOURTABLE_1', YOURTABLE_2')
Code: Select all
AND membership_grouppermissions.tablename IN ('YOURTABLE_1')
Code: Select all
AND membership_grouppermissions.tablename = 'YOURTABLE_1'
Code: Select all
select
membership_grouppermissions.tablename as 'tablename',
count(*) as 'num_editors',
group_concat(membership_users.memberID ORDER BY membership_users.memberID SEPARATOR ', ') as 'editors'
from membership_grouppermissions
inner join membership_groups on membership_grouppermissions.groupID=membership_groups.groupID
inner join membership_users on membership_groups.groupID = membership_users.groupID
where membership_grouppermissions.allowEdit
AND membership_grouppermissions.tablename IN ('YOURTABLE_1', 'YOURTABLE_2')
group by tablename
order by 1
Code: Select all
select group_concat(membership_grouppermissions.tableName ORDER BY membership_grouppermissions.tableName SEPARATOR ', ') as tablename, membership_users.memberid FROM `membership_grouppermissions` left JOIN membership_users on membership_users.groupID=membership_grouppermissions.groupID where membership_grouppermissions.allowEdit and tableName in ('YOURTABLE_1','YOURTABLE2') group by membership_users.memberid HAVING count(membership_grouppermissions.groupid) = 2