MSSQL - User Permission Report

Does anybody have code that would traverse an object's container (identified as input %1) and list all group/user permissions for the object and it's child objects?Thanks in advance.Sean

Find more posts tagged with

Comments

Steve_McDonough

Sean,I don't have specifically what you are looking for, but you might improve on the attached LiveReport. After all the great LiveReports that I found on the Knowledge Center discussion, hopefully this will pay forward the favor.Regards,Leon

OSHA_ICT_team_member_1_(oshauser1_-_(deleted))

Looks great, yes but it gives me error

has anyone adapted this livereport on folder permissions to make it work with an Oracle database ?

Filippo_Bianchini_(x-fbianchini_-_(deleted))

Message from Filippo Bianchini via eLinkyou should try the attached file-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: lunedì 30 agosto 2004 13:15To: eLink RecipientSubject: version for oracleversion for oraclePosted by Adib, Lila on 08/30/2004 07:14 AMLooks great, yes but it gives me error :(has anyone adapted this livereport on folder permissions to make it workwith an Oracle database ?[To reply to this thread, use your normal E-mail reply function.]============================================================Topic: MSSQL - User Permission Reporthttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=3655799&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 "Questo messaggio ed ogni suo allegato sono confidenziali e possono essere riservati o, comunque, protetti dall'essere diffusi. Se il ricevente non é il destinatario diretto del presente messaggio, è pregato di contattare l'originario mittente e di cancellare questo messaggio ed ogni suo allegato dal sistema di posta. Se il ricevente non é il destinatario diretto del presente messaggio, sono vietati l'uso, la riproduzione e la stampa di questo messaggio e di ogni suo allegato, nonché la diffusione del loro contenuto a qualsiasi altro soggetto" "This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, please contact the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not use, copy or print this message or attachment or disclose the contents to any other person."

OSHA_ICT_team_member_1_(oshauser1_-_(deleted))

with a few little customisations, this would become perfect, thanks I'll try to do them and then share it back

Will_Brantley

Leon..Thanks so much for the .rpt. When I run it on an object, I am returned "no results". Any ideas off the top of your head? If not, I'll delve into the code myself.Thanks again,Sean

x-unileveruser11_-_(deleted)

If you want an OScript alternative, take a look at http://www.greggriffiths.org/livelink/addons/containersize/