In Livelink we can define different security at different level of folders.I means giving users and groups access to foldrs.
I wanted to know up to which level security is defined and then below that level security is just inherited using Query? I am using below Query to know the security defined at different folder levels.
select distinct level as LVL, AUX.dataid, PRIM.name, K.name as UserOrGroup,K.type,AUX.parentid,
nvl( rtrim( decode( mod( trunc(D.permissions/32768), 2), 0, '', 1, 'See Content / ' ) ||
decode( mod( trunc(D.permissions/65536), 2), 0, '', 1, 'Modify / ' ) ||
decode( mod( trunc(D.permissions/16), 2), 0, '', 1, 'Edit Permissions / ' ) ||
decode( mod( trunc(D.permissions/8), 2), 0, '', 1, 'Delete / ' ) ||
decode( mod( trunc(D.permissions/4), 2), 0, '', 1, 'Add Children ' ), '/ ' ), 'none' ) as Perms
from dtree AUX
right outer join webnodes PRIM
ON PRIM.dataid = AUX.dataid
LEFT OUTER JOIN dtreeacl D
ON PRIM.dataid = D.dataid
RIGHT OUTER JOIN kuaf K
ON D.rightid = K.id
where AUX.subtype = 0
start with AUX.dataid = 2000
connect by prior AUX.dataid = AUX.parentid
AND PRIM.dataid in (select dataid from dtreeAncestors where AncestorID=2000)
AND PRIM.subtype='0' and level <6
order by LVL
But this query is working up to level 6. I have total 19 levels and Query just running for almost 1 days and not giving any result may be beacuse of data which is 450 GB or large number of folders.
How can I know security defined in livelink using Query? I want to know folders, users and permission associated with it, and up to what level it is defined and then later on just inherited.
