fhg
Volume 11, Number 29 -- October 5, 2011

Admin Alert: How to Retrieve Password Parameters for Auditors

Published: October 5, 2011

by Joe Hertvik

Your organization's fiscal year may have ended on September 30. Meaning you could soon be visited by auditors looking for information on how your organization operates its AS/400-class machine (iSeries, System i, Power i). Your auditors will be particularly interested in your password configuration parameters and whether they meet standards. To that end, here's a quick drill for retrieving password setup values at audit time.

What Auditors Want

Auditors generally require you to provide the following sets of password related parameters.

  • Your password configuration parameters--The rules users follow for creating passwords.
  • Configuration and program code for Password Validation Program (optional)--Many shops use password validation programs to impose additional rules above what the configuration parameters require.

Here's how to retrieve both groups of information.

Password Configuration Parameters

Auditors always request system password configuration parameters, the rules users must follow when selecting a new password. There are two ways to retrieve these settings on AS/400-class machines. You can generate a printout from a 5250 green screen; or you can copy them from System i Navigator (OpsNav) password screens.

The green screen method is the easiest to use. Run the following Work with System Values (WRKSYSVAL) command to print all your password configuration settings.

WRKSYSVAL SYSVAL(QPWD*) OUTPUT(*PRINT)

All password system value names start with QPWD (QPWDMAXLEN for maximum password length, QPWDMINLEN for minimum password length, etc.). Each value is listed with its current setting, its shipped (default) setting, and its system value description.

OpsNav can be used to present password parameters more clearly. But it takes a little more work to prepare the printout. Here's how to pull and present password parameters from OpsNav.

1. Open a new Microsoft Word document.

2. Open the Security→Policies node under your target partition. Click on the Password Policy entry that appears in the right-hand pane. This brings up the Password Policy Properties screen shown here.



3. Click on the General tab on the Password Policy Properties screen and press the ALT→PrtSc keystroke combination. This copies just the general password policy parameters to the Windows clipboard. Alt→Tab over to Word and paste this screen copy into your document.

4. Go back to the Password Policy screen and repeat the process after clicking on the Validation and the Expiration tabs. Copy these screens into the Word document.

5. Give the saved Word document to your auditors.

Password Validation Programs and Auditors

Many shops use a password validation program (PVP) to impose extra restrictions on passwords that differ from what the system password parameters require. Auditors are also interested in these programs.

To explain how PVPs affect your audit, let's assume a shop requires minimum 15-character pass phrases for all users. Let's also say Program X (a third-party iSeries client software) requires users to sign on to your iSeries machine using a 10-character password input field. This means that any 15-plus-character pass phrase user can't access Program X. Because Program X users need 10-character or less passwords, we must allow for 10-character maximum password users as well as 15-plus-character minimum passphrase users on the system. That's where a PVP comes in.

A PVP is a custom-written program that runs after a newly-created password has been validated by your system's password parameters. The PVP performs additional password checking beyond your system values, and it approves or denies new passwords based on these additional checks.

To create our two-tier password system, we would set up our Maximum password length (QPWDMINLEN) system value to 10 characters, and our Minimum password length (QPWDMINLEN) system value to six characters. This means every user needs to create passwords that are six-to-10 characters long. For every Program X user, we would add them to a special Program X user group. Then we would write a PVP according to IBM standards that evaluates new passwords by doing two things:

  1. For users in the Program X group, no further processing is required if their password is six-to-10 characters long and meets the other password criteria.
  2. For users who are not in the Program X group, the PVP checks their password to see if it is 15 characters or longer. If less than 15 characters, it will not accept the password and the user must enter a longer value.

The PVP is attached to IBM's exit point for password validation. In this way, the PVP creates our two-tier password system by imposing additional password standards above what the system requires.

For a more detailed explanation of password validation programs, see this article on placing additional restrictions on i/OS passwords.

Why Auditors Like PVPs

Auditors are interested in PVPs because they create a secondary password verification system. For a two-tier password system, the auditors must ensure that only the exemptions get the shorter passwords (i.e., you're not accidentally or intentionally skirting the requirements).

To document PVP usage, you can provide the auditor with the following items from your iSeries system.

First, a printout of the Password Validation Program (QPWDVLDPGM) system value. QPWDVLDPGM either contains the name and library of your PVP or it contains the literal *REGFAC. When QPWDVLDPGM is set to *REGFAC, the program name is retrieved from the QIBM_QSY_VLD_PASSWRD system exit point. Use the following Display System Value (DSPSYSVAL) command to print out the QPWDVLDPGM value.

DSPSYSVAL SYSVAL(QPWDVLDPGM) OUTPUT(*PRINT)

Give the resulting printout to the auditor.

Then, if the program name is registered with the system validation exit point (QIBM_QSY_VLD_PASSWRD), run these commands to get a printout of your exit point and the name of your exit program.

Use the Work with Registration Information (WRKREGINF) command to display the QIBM_QSY_VLD_PASSWRD exit point.

WRKREGINF EXITPNT(QIBM_QSY_VLD_PASSWRD)


Take Option 8=Work with exit program to display the name of your PVP on this screen.



Print and give this screen to the auditor.

Finally, if you're using a PVP, print the PVP source code and give it to the auditor.

i OS Password Related System Values

Finally, here are the names and description of all the password system values. This list can be given to the auditors to help them understand what each system value does.


System Value

iSeries Navigator (OpsNav) Password Policy Name

Password Composition rule

QPWDEXPITV

Password expiration interval

Specifies number of days passwords are valid.

QPWDLMTAJC

Restrict Consecutive Digits

Don't allow two consecutive numeric digits (0-9) in a password

QPWDLMTCHR

Restricted Characters

Don't allow specific characters to be used in password

QPWDLMTREP

Restrict Repeating Characters

Specifies whether the same character can be used twice in the password, or whether the character can be repeated consecutively (ex., 'BBBBB')

QPWDLVL

Password level

Overall system password level. QPWDLVL must be set to ‘2’ or higher when using passwords or passphrases longer than 10 characters.

QPWDMAXLEN

Maximum Length

Maximum length of the entered password

QPWDMINLEN

Minimum Length

Minimum length of the entered password

QPWDPOSDIF

Require a new character in each position

Password cannot contain any of the same characters in the same positions that they occupied in the previous password

QPWDRQDDGT

Require at least one digit

Password must contain at least one number (0-9)

QPWDRQDDIF

Password re-use cycle

Password cannot be the same as any of the previous 4, 6, 8, 10, 12, etc passwords previously entered by this user

QPWDVLDPGM

Password validation program

Specifies either the name of the password validation program; or *REGFAC to specify program is designated in QIBM_QSY_VLD_PASSWRD exit point


RELATED STORY

Placing Additional Restrictions on i/OS Passwords



                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot


Sponsored By
THE 400 SCHOOL - INSTRUCTOR DAN RIEHL

Live Training Workshops for the IBM i

RPG, COBOL, Control Language,
Operations, System Administration,
Security Management, Query and SQL
Live RPG IV and COBOL Boot Camps

Attend Live classes Online in our "Virtual Classroom for the IBM i"
or we can present these same classes on-site at your offices worldwide.

                         A Few of the many Benefits:
                          The 400 School, providing training for over 25 years
                          Industry expert Dan Riehl is the Live Instructor
                          Full Length 3, 4 and 5-Day Classes
                          Live Video and Audio – Always see and hear the Instructor, and other students
                          Avoid the heavy cost of Travel for our Online Workshops
                          Log on to our IBM System i for class and for Supervised Hands-On Labs
                          Special discounts for multiple students - up to 50%

Check out the Schedule for Online Classes


Senior Technical Editor: Ted Holt
Technical Editor: Joe Hertvik
Contributing Technical Editors: Edwin Earley, Brian Kelly, Michael Sansoterra
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

System i Developer:  Join the Gurus at the RPG & DB2 Summit in St. Louis, October 17-19
The 400 School:  LIVE Online Training RPG IV & COBOL Boot Camps
Shield Advanced Solutions:  Access IBM i data & objects from Linux & Windows Servers using PHP


 

IT Jungle Store Top Book Picks

BACK IN STOCK: Easy Steps to Internet Programming for System i: List Price, $49.95

The iSeries Express Web Implementer's Guide: List Price, $49.95
The iSeries Pocket Database Guide: List Price, $59
The iSeries Pocket SQL Guide: List Price, $59
The iSeries Pocket WebFacing Primer: List Price, $39
Migrating to WebSphere Express for iSeries: List Price, $49
Getting Started with WebSphere Express for iSeries: List Price, $49
The All-Everything Operating System: List Price, $35
The Best Joomla! Tutorial Ever!: List Price, $19.95


 
The Four Hundred
Oracle Takes The Midrange Fight To IBM

Business Risk Analysis: The New 'Alba'-rithm

Velocity Buys JD Edwards App Hoster WTS

Mad Dog 21/21: Bier Or Hospice, That Persistent Thirst For Legacy

Great People With Good Tools

Four Hundred Stuff
Seagull Delivers Major New Release of LegaSuite

Crossroads Shrinks its SPHiNX VTL, Adds SAS Support

Mobile Malware Set to Explode, Security Pros Say

Vision Updates Database Replication Solution

Attunity Unveils New Data Replication Suite

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

System i PTF Guide
October 1, 2011: Volume 13, Number 4

September 23, 2011: Volume 13, Number 3

September 17, 2011: Volume 13, Number 2

September 10, 2011: Volume 13, Number 1

September 25, 2010: Volume 12, Number 39

September 18, 2010: Volume 12, Number 38

TPM at The Register
Oracle rolls its own NoSQL and Hadoop

There'll be nothing left of IBM once I'm done, says Ellison

Citrix stretches XenServer 6.0 to cover bigger iron

Ellison brandishes 'speed of thought' Exalytics appliance

Apotheker severance outrage: $2.4m 'bonus'

Heroku floats heavenly Python into platform cloud

Oracle revs up Sparc, speeds up roadmap

Global data center building booms

AMD misses Q3 revenue targets

US tops the class in IT competitiveness

HP parks Airbus supers in containers

Revolution speeds stats on Hadoop clusters

THIS ISSUE SPONSORED BY:

SEQUEL Software
WorksRight Software
The 400 School


Printer Friendly Version


TABLE OF CONTENTS
Call Again and Again and Again...

Another Way to Pass Parms to SBMJOB

Admin Alert: How to Retrieve Password Parameters for Auditors

Four Hundred Guru

BACK ISSUES




 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2011 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement