LiveReport for Oracle - Object Owners

Patty_Bristol_(pbristol@momentumsystems.com_(Delet

Hi, does anyone have a LiveReport for Oracle that can be used to determine items owned by particular users? Thanks,Patty

Find more posts tagged with

Comments

Tim_Hunter

Patty, this should handle it for youSELECT DTree.dataid ,KUAF.Name UserName ,DTree.Name Object ,nvl(st.subtype, 'UNK: '||DTree.subtype) as ObjType ,DTreeACL.Permissions ,DECODE (DTREEACL.PERMISSIONS , '128' ,'No Rights' ,'130','S' ,'36995','S/SC' ,'62666','S/M' ,'102531','S/SC/M' ,'65670','S/M/AI' ,'102547','S/SC/M/EP' ,'233603','S/SC/M/EA' ,'102535','S/SC/M/AI' ,'118915','S/SC/M/DV' ,'233619','S/SC/M/EP/EA' ,'102551','S/SC/M/EP/AI' ,'118931','S/SC/M/EP/DV' ,'233607','S/SC/M/EA/AI' ,'249987','S/SC/M/EA/DV' ,'118919','S/SC/M/AI/DV' ,'233623','S/SC/M/EP/EA/AI' ,'250003','S/SC/M/EP/EA/DV' ,'118935','S/SC/M/EP/AI/DV' ,'249991','S/SC/M/EA/AI/DV' ,'250007','S/SC/M/EP/EA/AI/DV' ,'118923','S/SC/M/DV/D' ,'127107','S/SC/M/DV/R' ,'127115','S/SC/M/DV/D/R' ,'118939','S/SC/M/EP/DV/D' ,'127123','S/SC/M/EP/DV/R' ,'127131','S/SC/M/EP/DV/D/R' ,'249995','S/SC/M/EA/DV/D' ,'258179','S/SC/M/EA/DV/R' ,'258187','S/SC/M/EA/DV/D/R' ,'118927','S/SC/M/AI/DV/D' ,'127111','S/SC/M/AI/DV/R' ,'127119','S/SC/M/AI/DV/D/R' ,'250011','S/SC/M/EP/EA/DV/D' ,'258195','S/SC/M/EP/EA/DV/R' ,'258203','S/SC/M/EP/EA/DV/D/R' ,'118943','S/SC/M/EP/AI/DV/D' ,'127127','S/SC/M/EP/AI/DV/R' ,'127135','S/SC/M/EP/AI/DV/D/R' ,'249999','S/SC/M/EA/AI/DV/D' ,'258183','S/SC/M/EA/AI/ DV/R' ,'258191','S/SC/M/EA/AI/DV/D/R' ,'250015','S/SC/M/EP/EA/AI/DV/D' ,'258199','S/SC/M/EP/EA/AI/DV/R' ,'258207','Full Perm' ,'16777215','Full Perm' ,'Unk:'||DTREEACL.PERMISSIONS) as Rights FROM DTreeACL,KUAF,DTree,ll_subtypes stWHERE DTreeACL.DataID = DTree.DataID AND DTreeACL.RightID = KUAF.ID AND dtree.subtype = st.id(+) AND DTreeACL.RightID = %1

Patty_Bristol_(pbristol@momentumsystems.com_(Delet

Thanks very much!

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

Select * from DTree where UserID = %1 and SubType in (0,144)

Input Type : User

Prompt : Select a user to see what he/she owns

Param %1 : UserInput1

Report Format: LiveReport

The above query limits itself to folders and documents. For all object types, use:

Select * from DTree where UserID = %1

Additional details on DTree.UserID can be found in a posting here:

https://knowledge.opentext.com/knowledge/llisapi.dll/open/16354206

Let me know if that helps...

- Bhupinder----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, August 11, 2009 12:35 PM
To: eLink Recipient
Subject: LiveReport for Oracle - Object Owners

LiveReport for Oracle - Object Owners

Posted by pbristol@momentumsystems.com (Bristol, Patty) on 2009/08/11 12:33

Hi, does anyone have a LiveReport for Oracle that can be used to determine items owned by particular users?

Thanks,
Patty