Help. Report on permissions

I'm on a client site and the PM would like a report that would list all the users and their permissions for various folders. Could someone help me. Thanks.

Find more posts tagged with

Comments

Bob_De_Garmo_(degarmob_(Delete)_2518944)

Do you wish to just dump out for a single folder? A folder and its contents? A folder, and all sub-folders? Or a folder, all its contents, and all sub-folders and their contents? << The latter can be a real killer if run from the Enterprise WS.. >>I have most of these that can be run either from a LiveReport prompting for Container, or for a Starting Point ObjectID << my personal preference, but a little on the Geeky side. >>, or from SQL*Plus, SQL*Navigator, or whatever your fav SQL Tool may be...Problem is, most of these that I have tend to get a little tailored to whatever situation I'm currently trying to straighten out. So perhaps I could feed you the mechanics of the SQL, and you could assemble whatever you like.Just let me know, and I'll give you what I can... Gotta run to lunch right now. I'll check back upon my return.-Bob

Grant_Edgar_(cgiadmin_-_(deleted))

Thanks for getting back to me so quick. I would be interested in a report for" a folder, all its contents, and all sub-folders and their contents".Unfortunately i'm not very familialr with creating reports Any assistance would be greatly appreciated.Thanks

Bob_De_Garmo_(degarmob_(Delete)_2518944)

Attached is a text file with SQL from which you can create a LiveReport. To accomplish this:1) Create a new LiveReport. Doesn't really matter where2) Set an Input to "Container" with an appropriate prompt. i.e., "Folder:"3) Paste in the SQL from the attachment into the appropriate Text Field4) Set "Param %1" to "User Input 1"5) Set "Report Format" to "Auto LiveReport"6) Click SaveSome caveats to this report:1) It is definitely ORACLE only, as it uses several ORACLE specific constructs2) Since it prompts for a Container, which is Livelink controlled, you will only be able to select items of that nature. i.e., You cannot select Enterprise Workspace; it is not recognized as a "Container." Same for Personal Workspaces... If this is an issue, the report can easily be modified to where the input is a User provided ObjectID simply by removing the "Input" settings in the LiveReport...3) It does not work real well for Projects, as their lineage works differently than Folders due to the creation of a new "volume" 4) Probably more that I'm not remembering, and/or are unknown to me... In other words, I hope this works for you, but it is definitely provided "As Is"...Good Luck, Rita!!!-Bob

Bob_De_Garmo_(degarmob_(Delete)_2518944)

The SQL is hardcoded to only show an object's lineage back two levels. i.e., Folder1:Folder2:ObjectNm.If the lineage starts right off the Enterprise Workspace, Outer Joins are used to pick up the rows. If the lineage starts deeper than two levels, folder names are only shown back two...Hope that makes sense!!! If not, it probably will once you run the report a few times...-Bob

eLink User

Message from Marie Lindsay via eLinkI can't help mentioning that the v9 XMLExport function with a stylesheetapplied might be useful to you here. To quickly see the kind of permissionsinfo you can get in XML format, visit the folder whose contents you'reinterested in using IE 5, then change everything after "objaction=" in theURL, ending the URL with "objaction=xmlexport&nodeinfo".The LL 9.0.0.1 release notes document the XMLExport action. The new XMLSkins course explains the XMLExport action and how to create XML skins--seewww.opentext.com/training for details.Marie Lindsay> -----Original Message-----> From: knowledge@opentext.com [mailto:knowledge@opentext.com]On Behalf Of> eLink Discussion: Livelink LiveReports Discussion> Sent: Tuesday, June 26, 2001 12:03 PM> To: eLink Recipient> Subject: permission reports>>> permission reports> Posted by CGIAdmin on 06/26/2001 12:59 PM>> Thanks for getting back to me so quick. I would be interested in> a report for" a folder, all its contents, and all sub-folders and> their contents".>> Unfortunately i'm not very familialr with creating reports Any> assistance would be greatly appreciated.>> Thanks>> [To reply to this thread, use your normal e-mail reply function.]>> ============================================================>> Topic: Help. Report on permissions> https://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2538721&objAction=viewDiscussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Grant_Edgar_(cgiadmin_-_(deleted))

Thanks for your help bob.