Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
Groups not used for permissions
Evert_Kuiken_(ekuiken_-_(deleted))
Hi,We want to clean our system from groups that are no longer in use. I created a LiveReport to find out all groups in our system that are no longer used to grant permissions to any object. Can anyone verify this as it seems to show groups that are still in use. Is there for instance another table where persmissions are stored than DTREEACL?SELECT groep.ID, groep.NAME AS "Groepsnaam", groepleader.NAME AS "Groupleader",groepleader.firstname || ' ' || groepleader.lastname AS "Naam persoon",groepleader.mailaddress AS "Groupleader E-mail adres"FROM kuaf groep, kuaf groepleaderWHERE groep.TYPE = 1AND groep.ID NOT IN (SELECT rightidFROM dtreeacl)AND groep.deleted = 0AND groep.leaderid = groepleader.ID
Find more posts tagged with
Comments
Tim_Hunter
DTREEACL is the only table used to store permissions as far as I knowYour query seems to be valid, its possible however that the use of subgroups is why you might think otherwise as this would only show direct assignments.
