Re: Which objects do not have an authorization list
[email protected] Mon, 11 May 2009 16:06:16 -0400
| Newsgroups | gmane.comp.systems.as400.security |
|---|---|
| Message-ID | <OFEB9F4395.57EFC40A-ON852575B3.006D687A-852575B3.006E7056@dekko.com> |
The OP wanted to know which objects in a library are not secured by an authorization list. Using PRTPUBAUT I would have to run it for every possible object type supported by PRTPUBAUT (four screens of two columns each in the help). May I suggest the use of QSYLUSRA? You could wrapper that with a User Defined Function or UDF and do the following: DSPOBJD ... OUTPUT(*OUTFILE) OUTFILE(QTEMP/MYFILE) STRSQL SELECT ODLBNM, ODOBNM, ODOBTP, GetAuthList(ODLBNM, ODOBNM, ODOBTP) FROM QTEMP/MYFILE WHERE ODLBNM='somelib' Or you could use QSYLUSRA from either the Open list of objects api or the display list of objects api. Rob Berendt -- Group Dekko Services, LLC Dept 01.073 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com From: "Barb Hines" <BHines-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> To: "Security Administration on the AS400 / iSeries" <security400-Zwy7GipZuJhWk0Htik3J/[email protected]> Date: 05/11/2009 03:42 PM Subject: Re: [Security400] Which objects do not have an authorization list Sent by: security400-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] One way would be to specify the object type. -----Original Message----- From: security400-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:security400-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of [email protected] Sent: Monday, May 11, 2009 1:27 PM To: Security Administration on the AS400 / iSeries Subject: Re: [Security400] Which objects do not have an authorization list How would that work? If I have a *FILE, a *PGM and a *DTAARA how would I use PRTPUBINF to find which of these does not have an authorization list? Rob Berendt -- Group Dekko Services, LLC Dept 01.073 Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com From: "Barb Hines" <BHines-9lM15Z0VR04AUIqCBpNi1wC/[email protected]> To: "Security Administration on the AS400 / iSeries" <security400-Zwy7GipZuJhWk0Htik3J/[email protected]> Date: 05/08/2009 12:03 PM Subject: Re: [Security400] Which objects do not have an authorization list Sent by: security400-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] Hello Marc, The command is PRTPUBAUT. Barbara Hines Programmer / Analyst Allied Machine & Engineering Corp. -----Original Message----- From: security400-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:security400-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Zylka Marc Sent: Friday, May 08, 2009 11:50 AM To: security400-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [Security400] Which objects do not have an authorization list Hello, Is there a command that I can use to see which objects do not have an authorization list in a particular library? I tried the DSPOBJD command but it does not include the authorization list. I need to find the objects which don't have an authorization list assigned. Thanks in advance, _______________________________________________ Marc Zylka Applications System Analyst/Programming Supervisor Volvo Information Technology _______________________________________________ This is the Security Administration on the AS400 / iSeries (Security400) mailing list To post a message email: Security400-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/security400 or email: Security400-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/security400. _______________________________________________ This is the Security Administration on the AS400 / iSeries (Security400) mailing list To post a message email: Security400-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/security400 or email: Security400-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/security400. _______________________________________________ This is the Security Administration on the AS400 / iSeries (Security400) mailing list To post a message email: Security400-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/security400 or email: Security400-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/security400. _______________________________________________ This is the Security Administration on the AS400 / iSeries (Security400) mailing list To post a message email: Security400-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/security400 or email: Security400-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/security400. _______________________________________________ This is the Security Administration on the AS400 / iSeries (Security400) mailing list To post a message email: Security400-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/security400 or email: Security400-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/security400.