How many users have access rights to a special folder

Peter_Arens

Hello,

how do I get out how many users have access rights to folders? That is very complicated to count, because we do have folders with groups which contain more groups as subgroups.

The other possibility would be, to count all users of a group including the users of the supgroups.

Thank you

Peter

John Simon

Peter - If you are using oracle you can use the old "connect by" to traverse group memebership.  Here is an example (replace the XXXXX with a group id):

select * 
from kuaf 
where id in(
select childid
from kuafchildren
start with id = XXXXXX
connect by prior childid = id
)
and type = 0
and deleted = 0
order by id

Hopefully you can use this as a start.

Cheers...