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.