List permissions a group has on a folder's items

Hey does anyone know how to list what permissions a specified group has on a specific folder's items?

Find more posts tagged with

Comments

Message from Coursey, Jim <jim.coursey@ngc.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

What DB server are you using?

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, August 14, 2007 5:09 PM
To: eLink Recipient
Subject: List permissions a group has on a folder's items

List permissions a group has on a folder's items

Posted by bmays (Mays, Belinda) on 08/14/2007 05:08 PM

Hey does anyone know how to list what permissions a specified group has on a specific folder's items?

Heidi_Hudler-Canales

We are using oracle 9i DB and Solaris 9 operating system

Tim_Hunter

This will give you a list of all objects by groupID, pass in %1 as groupidSELECT A.DATAID as folderid ,D1.NAME as ObjectName ,D1.DATAID ,nvl(st.subtype, 'UNK: '||d1.subtype) as ObjType ,CASE A.RIGHTID WHEN -1 THEN 'Public Access' WHEN -2 THEN 'System Administrators' ELSE 'Group ID: ' ||A.RIGHTID END as privsassignedto ,CASE A.Permissions WHEN 128 THEN 'No Rights' WHEN 130 THEN 'S' WHEN 36995 THEN 'S/SC' WHEN 36999 THEN 'S/SC/AI' WHEN 62666 THEN 'S/M' WHEN 65670 THEN 'S/M/AI' WHEN 102531 THEN 'S/SC/M' WHEN 102535 THEN 'S/SC/M/AI' WHEN 102547 THEN 'S/SC/M/EP' WHEN 102551 THEN 'S/SC/M/EP/AI' WHEN 118915 THEN 'S/SC/M/DV' WHEN 118919 THEN 'S/SC/M/AI/DV' WHEN 118923 THEN 'S/SC/M/DV/D' WHEN 118927 THEN 'S/SC/M/AI/DV/D' WHEN 118931 THEN 'S/SC/M/EP/DV' WHEN 118939 THEN 'S/SC/M/EP/DV/D' WHEN 118935 THEN 'S/SC/M/EP/AI/DV' WHEN 118943 THEN 'S/SC/M/DP/AI/DV/D' WHEN 127107 THEN 'S/SC/M/DV/R' WHEN 127111 THEN 'S/SC/M/AI/DV/R' WHEN 127115 THEN 'S/SC/M/DV/D/R' WHEN 127119 THEN 'S/SC/M/AI/DV/D/R' WHEN 127123 THEN 'S/SC/M/EP/DV/R' WHEN 127127 THEN 'S/SC/M/EP/AI/DV/R' WHEN 127131 THEN 'S/SC/M/EP/DV/D/R' WHEN 127135 THEN 'S/SC/M/EP/AI/DV/D/R' WHEN 233603 THEN 'S/SC/M/EA' WHEN 233607 THEN 'S/SC/M/EA/AI' WHEN 233619 THEN 'S/SC/M/EP/EA' WHEN 233623 THEN 'S/SC/M/EP/EA/AI' WHEN 249987 THEN 'S/SC/M/EA/DV' WHEN 249991 THEN 'S/SC/M/EA/AI/DV' WHEN 249995 THEN 'S/SC/M/EA/DV/D' WHEN 249999 THEN 'S/SC/M/EA/AI/DV/D' WHEN 250003 THEN 'S/SC/M/EP/EA/DV' WHEN 250007 THEN 'S/SC/M/EP/EA/AI/DV' WHEN 250011 THEN 'S/SC/M/EP/EA/DV/D' WHEN 250015 THEN 'S/SC/M/EP/EA/AI/DV/D' WHEN 258179 THEN 'S/SC/M/EA/DV/R' WHEN 258183 THEN 'S/SC/M/EA/AI/DV/R' WHEN 258187 THEN 'S/SC/M/EA/DV/D/R' WHEN 258191 THEN 'S/SC/M/EA/AI/DV/D/R' WHEN 258195 THEN 'S/SC/M/EP/EA/DV/R' WHEN 258199 THEN 'S/SC/M/EP/EA/AI/DV/R' WHEN 258203 THEN 'S/SC/M/EP/EA/DV/D/R' WHEN 258207 THEN 'Full Permissions' WHEN 16777215 THEN 'Admin' ELSE 'Unk: ' ||A.Permissions END as Permissions ,K.NAME as GroupNameFROM DTREE D1 , DTREEACL A , KUAF K ,ll_subtypes stWHERE A.DATAID = D1.DATAID AND A.ACLTYPE = 0 /* AND D1.SUBTYPE = 0 -- FOLDERS ARE 0 */ AND D1.subtype = st.id(+) AND K.ID = A.RIGHTID AND A.RIGHTID IN (%1)ORDER BY K.NAME, D1.NAME