LiveReport or SQL Query to display the permissions in a format

Is there a LiveReport that can display the results for the folders as in the attached folder hierarchy/structure and against each folder the permissions in terms of read only (if it is see, see contents), write-no delete (if it is see, see contents, edit attributes, add items, reserve, modify), write (if it is see, see contents, edit attributes, add items, reserve, modify, delete permissions) and full access (if it is see, see contents, edit attributes, add items, reserve, modify, delete and edit permissions) are displayed.If there is no Livereport, is it possible to pull this information in the above mentioned/attached format from SQL? Please help me know asap.

Find more posts tagged with

Comments

Tim_Hunter

do you want to see the permissions for the current user or any user/groups.I don't understand how you want the output to look in the case there are several groups which have the specified permission in each folder. I have several SQL queries (oracle) which will give permissions on objects/folders (and subfolders) but I am not sure of how to match to your sample output screen.

Atiya_Sultana

Hi Tim,Thanks for the reply.My requirement is as attached in the screenshot.I want a Livereport or SQL query which can output the data in the above format. Below is the description:* On FolderA, I want to which all users or groups have read, write-no delete, write access. * Similary inside FolderA, there are many sub-folders and inside those sub-folders again many sub-folders. So I want to display the permissions in a folder hierarchy so that against each folder (be a top level or sub-folder), the above mentioned permissions are displayed.* But the display should be in the form of parent-child relation. That is, if FolderA has got 10 sub-folders, then in the next column to FolderA's column, those 10 folders should be displayed. Same for all top level folders (FolderB).Please help me achive the above. If you have any LiveReports and SQL queries, please forward.Awaiting your reply eagerly. You can reply either to the discussion post or directly to my email id.Many Thanks,Atiya.

Tim_Hunter

The problem with getting it into your format is having to pivot the data from the way its stored in the database.The query attached will give you a row for every permission on an object ordered by the level and sublevels, however it wont show the staggering, you will have to play with the hierarchical functions in oracle (specifically lpad and level), here is a good reference:http://philip.greenspun.com/sql/trees.htmlI didn't bother with it since I did all of my logic in a WebReport on top of this LiveReport.The attached should give you very close to what you want

Atiya_Sultana

Tim,Thanks much for the reply.I get error when I execute the attached query. Can you help me know whats the problem here.Many Thanks,Atiya.

Tim_Hunter

I wrote the query for an oracle database, it will in no way work for SQL ServerYou could probably look around the forums here for how to get hierarchy in MS SQL or possibly online, but i don't have access to MSSQL.

Craig_Stanley

Message from via eLinkFor any kind of Permissions work, we have tried many options and have nowfound that using Blubaker's tool Dataxs / Permissions XS as the best way ofreporting and updating permissions. I think that this is distributedthrough Opentext now.This solution has saved us a great deal of time and manual processing.Hope this helpsCraig StanleyInformation ServicesNorthumbrian Water0191 301655507715547424craig.stanley@nwl.co.uk|---------+-------------------------------------------->| | "eLink Discussion: Livelink || | LiveReports Discussion" || | || | || | 24/10/2008 14:05 || | Please respond to "eLink || | Discussion: Livelink LiveReports || | Discussion" || | ||---------+--------------------------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: "eLink Recipient" | | cc: | | Subject: something close | >------------------------------------------------------------------------------------------------------------------------------| something Posted by timothy.hunter.ctr@wpafb.af.mil (Hunter, Tim close ) on 10/24/2008 09:01 AM In reply to: Posted by atiya.sultana@accenture.com (Sultana, Atiya) Hi Tim, on 10/24/2008 08:24 AM The problem with getting it into your format is having to pivot the data from the way its stored in the database. The query attached will give you a row for every permission on an object ordered by the level and sublevels, however it wont show the staggering, you will have to play with the hierarchical functions in oracle (specifically lpad and level), here is a good reference: http://philip.greenspun.com/sql/trees.html I didn't bother with it since I did all of my logic in a WebReport on top of this LiveReport. The attached should give you very close to what you want Attachment Links: objectPermissions.txt (2 KB) [To reply to this thread, use your normal E-mail reply function.] Topic: LiveReport or SQL Query to display the permissions in a format Discussion: Livelink LiveReports Discussion Livelink knowledge-wlweb01 Server: To Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.E-MAIL INFORMATIONThis e-mail was received by the Northumbrian Water servers on Fri, 24 Oct2008 13:05:04 UT. At this point it was checked for all known viruses andthreats.You are reminded that there is no guarantee that the information containedwithin this e-mail is genuine. It is not possible to verify the originalsender of this e-mail, or to ensure that the information contained withinhas not since been altered.You are reminded that urgent or sensitive information should not be sentvia e-mail, as this is not a secure method of delivery. (See attached file:objectPermissions.txt)**********************************************************************Northumbrian Water and Essex & Suffolk Water - "Companies that Count" - Leading utility in the Business in the Community Corporate Responsibility Index and Big Tick Winner for its "Impact on Society"Responsible business is what we are and what we doThis communication is confidential and may contain privileged information intended solely for the named addressee(s). If you have received this in error, please notify Northumbrian Water Ltd by emailing service.desk@nwl.co.uk quoting the sender and delete the message and any attached documents. You should not copy it to anyone else. Please visit www.nwl.co.uk to report any billing enquiries, not the address above.Unless expressly stated, opinions in this message are those of the individual sender and not of Northumbrian Water Ltd.You should be aware that this message, and any reply to it, may have to be made public if requested under the Data Protection Act 1988; the Environmental Information Regulations 2004 or in connection with litigation.Northumbrian Water Limited, registered in England & Wales number 2366703. Registered office: Northumbria House, Abbey Road, Pity Me, Durham, DH1 5FJ.This footnote confirms that this email message has been swept by MIMEsweeper for Content Security threats, including computer viruses.www.nwl.co.uk

Atiya_Sultana

Hi Craig,Thanks for the reply.Let me know from where can i get that tool. Is that chargeable?Thanks,Atiya.

Atiya_Sultana

Hi All,Can anyone help me with this? I want to know information on Blubaker tool. How and from where to get it. And how to use it. Is this available free or chargeable.I opened a ticket with Open Text but got a reply that they cannot provide any information on it and I should contact my account manager. Since many of you must have used it, it would be really helpful if related information is passed. You can mail me at my email address too.Awaiting your reply.Thanks,Atiya.

Jeff_Brown_(G*_ECM_Champ)

Message from Brown, Jeff <Jeff.Brown@hatch.ca> via eLink

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

Ian Morrison
imorrison@blubaker.com

Director
Blubaker Limited
Tel : +44 (0)1224 619263
Mob : +44 (0)7718 923633

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, November 18, 2008 5:58 AM
To: eLink Recipient
Subject: About Blubaker tool

About Blubaker tool Posted by atiya.sultana@accenture.com (Sultana, Atiya) on 11/18/2008 05:56 AM
In reply to: Hi Craig, Posted by atiya.sultana@accenture.com (Sultana, Atiya) on 10/24/2008 11:53 AM

Hi All,

Can anyone help me with this? I want to know information on Blubaker tool. How and from where to get it. And how to use it. Is this available free or chargeable.

I opened a ticket with Open Text but got a reply that they cannot provide any information on it and I should contact my account manager.

Since many of you must have used it, it would be really helpful if related information is passed. You can mail me at my email address too.

Awaiting your reply.

Thanks,
Atiya.

N O T I C E - This message is intended only for the use of the individual or entity to which it is addressed and may contain information which is privileged, confidential or proprietary. Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, arrive late or contain viruses. By communicating with us via e-mail, you accept such risks. When addressed to our clients, any information, drawings, opinions or advice (collectively, "information") contained in this e-mail is subject to the terms and conditions expressed in the governing agreements. Where no such agreement exists, the recipient shall neither rely upon nor disclose to others, such information without our written consent. Unless otherwise agreed, we do not assume any liability with respect to the accuracy or completeness of the information set out in this e-mail. If you have received this message in error, please notify us immediately by return e-mail and destroy and delete the message from your computer.

Craig_Stanley

Message from via eLinkAtiyaWe use Blubaker toolset regularly and highly recommend the DataXs andPermissionsXS.Blubaker as a company have been terrific and we are happy to discuss ouruse of the product in more detailCraig StanleyInformation ServicesNorthumbrian Water0191 301655507715547424craig.stanley@nwl.co.uk|---------+-------------------------------------------->| | "eLink Discussion: Livelink || | LiveReports Discussion" || | || | || | 18/11/2008 12:55 || | Please respond to "eLink || | Discussion: Livelink LiveReports || | Discussion" || | ||---------+--------------------------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: "eLink Recipient" | | cc: | | Subject: RE About Blubaker tool | >------------------------------------------------------------------------------------------------------------------------------| RE About Blubaker Posted by jeffbrown (Brown, Jeff ) on 11/18/2008 tool 07:55 AM In reply to: About Posted by atiya.sultana@accenture.com (Sultana, Blubaker tool Atiya) on 11/18/2008 05:56 AM Message from Brown, Jeff via eLink Ian Morrison imorrison@blubaker.com Director Blubaker Limited Tel : +44 (0)1224 619263 Mob : +44 (0)7718 923633 From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: Tuesday, November 18, 2008 5:58 AM To: eLink Recipient Subject: About Blubaker tool About Blubaker Posted by atiya.sultana@accenture.com (Sultana, tool Atiya) on 11/18/2008 05:56 AM In reply to: Hi Posted by atiya.sultana@accenture.com (Sultana, Craig, Atiya) on 10/24/2008 11:53 AM Hi All, Can anyone help me with this? I want to know information on Blubaker tool. How and from where to get it. And how to use it. Is this available free or chargeable. I opened a ticket with Open Text but got a reply that they cannot provide any information on it and I should contact my account manager. Since many of you must have used it, it would be really helpful if related information is passed. You can mail me at my email address too. Awaiting your reply. Thanks, Atiya. N O T I C E - This message is intended only for the use of the individual or entity to which it is addressed and may contain information which is privileged, confidential or proprietary. Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, arrive late or contain viruses. By communicating with us via e-mail, you accept such risks. When addressed to our clients, any information, drawings, opinions or advice (collectively, "information") contained in this e-mail is subject to the terms and conditions expressed in the governing agreements. Where no such agreement exists, the recipient shall neither rely upon nor disclose to others, such information without our written consent. Unless otherwise agreed, we do not assume any liability with respect to the accuracy or completeness of the information set out in this e-mail. If you have received this message in error, please notify us immediately by return e-mail and destroy and delete the message from your computer. [To reply to this thread, use your normal E-mail reply function.] Topic: LiveReport or SQL Query to display the permissions in a format Discussion: Livelink LiveReports Discussion Livelink knowledge-wlweb01 Server: To Unsubscribe from this Discussion, send an e-mail tounsubscribe.livereportsdiscussion@elinkkc.opentext.com.E-MAIL INFORMATIONThis e-mail was received by the Northumbrian Water servers on Tue, 18 Nov2008 12:55:21 UT. At this point it was checked for all known viruses andthreats.You are reminded that there is no guarantee that the information containedwithin this e-mail is genuine. It is not possible to verify the originalsender of this e-mail, or to ensure that the information contained withinhas not since been altered.You are reminded that urgent or sensitive information should not be sentvia e-mail, as this is not a secure method of delivery.**********************************************************************Northumbrian Water and Essex & Suffolk Water - "Companies that Count" - Leading utility in the Business in the Community Corporate Responsibility Index and Big Tick Winner for its "Impact on Society"Responsible business is what we are and what we doThis communication is confidential and may contain privileged information intended solely for the named addressee(s). If you have received this in error, please notify Northumbrian Water Ltd by emailing service.desk@nwl.co.uk quoting the sender and delete the message and any attached documents. You should not copy it to anyone else. Please visit www.nwl.co.uk to report any billing enquiries, not the address above.Unless expressly stated, opinions in this message are those of the individual sender and not of Northumbrian Water Ltd.You should be aware that this message, and any reply to it, may have to be made public if requested under the Data Protection Act 1988; the Environmental Information Regulations 2004 or in connection with litigation.Northumbrian Water Limited, registered in England & Wales number 2366703. Registered office: Northumbria House, Abbey Road, Pity Me, Durham, DH1 5FJ.This footnote confirms that this email message has been swept by MIMEsweeper for Content Security threats, including computer viruses.www.nwl.co.uk

Atiya_Sultana

Hi Craig,Thanks for the reply.Can you please help me know whether it satisfies my requirement?And what is the cost for this tool.Regards,Atiya.

Craig_Stanley

I will send you through a sample report by email tomorrow so you can see. RegardsCraig

Atiya_Sultana

Hi Craig,Many thanks in advance for that.Awaiting for your mail.Regards,Atiya.

Atiya_Sultana

Hi Craig,If you get a chance, can you please reply.Thanks,Atiya.