fhg
Volume 9, Number 9 -- March 11, 2009

Admin Alert: Six Ways to Mess Up i5/OS User Profiles Security (And What To Do About It)

Published: March 11, 2009

by Joe Hertvik

Compared to other platforms, the i5/OS operating system is one of the more secure systems available today. However, that doesn't mean there aren't any security holes. This week, let's look at some common user profile security problems that iSeries, System i, and Power i shops encounter and talk about how you can counter these issues.

Auditing Your User Profiles

To truly troubleshoot the issues I'm discussing here, you'll need to create a user profile information file (UPIF). It's easy to create a UPIF and once you have it, you can query individual user profiles to determine which profiles have which user profile problems. For step-by-step instructions on how to create a user profile information file, see an earlier article I wrote titled The Joys of Creating User Profile Information Files.

Now, let's look at six of the more common user profile security issues you'll face on an i5/OS system. These problems are:

  1. Handing out *ALLOBJ authority to whomever asks for it, especially programmers
  2. Giving *ALLOBJ authority to group profiles
  3. Allowing user profiles to retain default passwords
  4. Allowing default *PUBLIC access to newly created i5/OS objects
  5. Passwords that never expire
  6. Allowing users to create easily guessed passwords

While these aren't the only security issues you'll face, you'll be able to improve your security exposure quite a bit if you get a handle on these problems.

Problem 1: Handing Out *ALLOBJ Authority To Whomever Asks For It, Especially Programmers

One of the worst things you can do is to indiscriminately provide all object (*ALLOBJ) authority to multiple users on your system. I've been in shops where administrators think that it's okay to provide this authority to one or two power users or vendors, because "…they really can't do their jobs without it." I also worked in one horrendously brain-dead place where their solution to access issues was to give *ALLOBJ authority to every user profile in the shop. That was a bad move.

The problem with granting *ALLOBJ authority is that if the user has it, there is almost nothing inside i5/OS that the user cannot reach, corrupt, and destroy. If you really want to tempt fate, give *ALLOBJ authority to your programmers who can easily make innocent mistakes that corrupt data and destabilize your system But take faith, there are better alternatives to *ALLOBJ authority for programmers and this article from a few years back by Wayne O. Evans discusses some of the issues involved with *ALLOBJ programmer access to data.

For more information on the perils of *ALLOBJ access and how to scale it back, see the articles in the RELATED STORIES section below.

Problem 2: Giving *ALLOBJ Authority To Group Profiles

Providing a group profile with *ALLOBJ authority is more dangerous than giving it to an individual user. Because i5/OS authority checking will also grant access based on group profile membership, if you give *ALLOBJ authority to a group profile, that authority is automatically transferred to all the individual user profiles who are members of that group.

To understand better how i5/OS performs authority checking when a user tries to access an object, see this article on the seven levels of i5/OS and OS/400 authority checking. After reading it, check some of your more critical group profiles and make sure that they don't have more access than is healthy for your shop.

Problem 3: Allowing User Profiles To Retain Default Passwords For Accessing The System

Default i5/OS and OS/400 passwords occur when a user profile's password value is the same as its corresponding user profile name (i.e., a user profile called JOE has a password of JOE). Active default passwords are a security risk because external hackers as well as malicious internal users can easily guess their existence and use them to sign on and create mischief on your system. Setting up a zero tolerance policy to detect and remove default passwords is in your best interests as a system administrator.

To help you detect and deal with default passwords, I created two articles exploring the ramifications of default passwords and how to detect and prevent them. Check out part 1 and part 2 of this series for more information.

Problem 4: Allowing Default *PUBLIC Access To Newly Created i5/OS Objects

By default, the Create Default Public Authority (QCRAUT) system value is set to *CHANGE. This means that for any new system objects that reference QCRAUT for default authority settings, those objects will be assigned *CHANGE authority for the *PUBLIC user. *CHANGE authority allows a user to read, modify, and delete file records in a physical or logical file. For a program object, *CHANGE authority allows the user to execute or modify the object. To shore up i5/OS security, you can read my two-part article on limiting *PUBLIC access to i5/OS objects. Follow these links to read part 1 and part 2.

Problem 5: Passwords That Never Expire

Because user passwords are frequently discovered or given away, you need to force your users to periodically change their password values. By default, i5/OS user profiles take their password expiration time limit from a system value called the Password Expiration Interval (QPWDEXPITV). This is accomplished by setting the user profile Password Expiration Interval (PWDEXPITV) parameter to *SYSVAL, which instructs i5/OS to refer to the QPWDEXPITV system value for the user's expiration interval. Be careful, however, because the shipped value for QPWDEXPITV is *NOMAX, which means that any user profiles referring to the password expiration system value will never be forced to change their password by the system. If you don't change that system value, most of your user profiles will have passwords with an unlimited expiration interval. Lowering the QPWDEXPITV system value to something reasonable, say 90 days, will have an impact on most of the user profiles in your shop.

Also note that the password expiration interval value can be overridden in a user profile. So even if you set QPWDEXPITV to a lower value than *NOMAX, a user with security administrator (*SECADM) authority could override his own user profile password expiration value and set it back to *NOMAX. For more information about password expiration intervals, see Creating an i5/OS User Profile Architecture. You can also discover who has overridden their PWDEXPITV user profile values by querying your user profile information file.

Problem 6: Allowing Users To Create Easily Guessed Passwords

One of the most chronic i5/OS security problems is also one of the easiest problems to fix. Many shops allow users to define easily guessed passwords for themselves, including default passwords; passwords that include easily guessed words; passwords including common numbers that have meaning for the user; and passwords that are similar to older passwords used by the user. To explain how i5/OS can help you create sufficiently complex passwords that protect system security while preventing your users from being unduly restricted, check out this article on eliminating easy-to-guess user passwords.

The /QOpenSys Matryoshka Doll

My shop found an unusual AS/400 Integrated File System (AS/400 IFS) issue this week. We used the Work with Object Links (WRKLNK) command to open the /QOpenSys file system to check out an issue in the bin (binary object) sub-directory, when we spotted another directory under /QOpenSys, which was also called . . . /QOpenSys!!! And to make matters stranger, this /QOpenSys/QOpenSys folder contained all the same directories that were present in the regular /QOpenSys folder.

Sensing something wrong, we looked closer at the /QOpenSys/QOpenSys folder and to our amazement, we found and opened a third nested /QOpenSys folder, which made our current folder path /QOpenSys/QOpenSys/QOpenSys. And like the second /QOpenSys folder, the directory structure from the original /QOpenSys directory was also present in this sub-folder.

Like an i5/OS Matryoshka Doll, we kept exploring nested /QOpenSys folders until we got to the last /QOpenSys sub-folder, which was located 15 layers deep from the root directory (/) of the AS/400 IFS. What was strange about this final /QOpenSys folder was that its directory structure looked like this.

                             Work with Object Links

Directory  . . . . :
/QOpenSys/QOpenSys/QOpenSys/QOpenSys/QOpenSys/QOpenS >

 Type options, press Enter.
   2=Edit   3=Copy   4=Remove   5=Display   7=Rename   
   8=Display attributes  11=Change current directory ...

 Opt   Object link            Type     Attribute    Text
       bin                    SYMLNK
       etc                    DIR
       lib                    SYMLNK
       sbin                   DIR
       usr                    DIR
       var                    DIR
       ICHA1.PNR              STMF
       QIBM                   DIR
       QOpenSys               SYMLNK

When we tried to open the Symbolic Link version of this /QOpenSys directory (designated by the SYMNK attribute type), we received an error saying "Path name resolution causes looping."

Contributing to the weirdness, we checked the /QOpenSys directories on the other five System i 550 partitions that are running in our shop. Four out of the five partitions that we checked had the same recursive /QOpenSys directory structure.

So I'll direct this question to all the Admin Alert readers out there. Is this a common situation? If so, what causes it and what if anything should be done about it? It doesn't seem to be affecting our applications, but I haven't seen much written about this problem in the available literature. Let me know what you think by contacting me via the IT Jungle Contacts page. All responses will be tallied and printed in a future column. And in the spirit of this column, there may even be some no-prizes involved. ;-)


RELATED STORIES

Auditing Users with All-Object Authority

Command Authority and LOGCMD

Creating an i5/OS User Profile Architecture

Eliminating Easy-to-Guess User Passwords

Getting Around System i Default Passwords, Part 1

Getting Around System i Default Passwords, Part 2

The Joys of Creating User Profile Information Files

Limiting All-Object Authority

Limiting *PUBLIC Access to i5/OS Objects, Part 1

Limiting *PUBLIC Access to i5/OS Objects, Part 2

The Seven Levels of OS/400 Authority Checking



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


Sponsored By
NORTHEAST USER GROUPS CONFERENCE

19th Annual Northeast IBM i
User Groups Conference
April 6 - 8, Framingham, MA

3 Days of Affordable, Quality Education

                                · 100+ sessions cover RPG & Programming Tools, Database,
                                   Systems Mgmt., & Web Development
                                · Top industry speakers; in-depth labs & workshops
                                · Expanded Management & Professional Development track

Register before March 14 and save!
$500 for 2 days; $700 w/Monday lab

View Conference Brochure
www.neugc.org


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

BCD:  Reaching your IBM i Web modernization goals is a lot closer with BCD
WMCPA:  24rd Annual Spring Technical Conference, April 1 & 2, 2009, Delavan, WI
COMMON:  Join us at the 2009 annual meeting and expo, April 26-30, Reno, Nevada


 

IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
Getting Started with PHP for i5/OS: List Price, $59.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket Developers' Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
iSeries Express Web Implementer's Guide: List Price, $59.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
WebFacing Application Design and Development Guide: List Price, $55.00
Can the AS/400 Survive IBM?: List Price, $49.00
The All-Everything Machine: List Price, $29.95
Chip Wars: List Price, $29.95


 
The Four Hundred
Getting Dizzy from Dynamic Infrastructure

The Economy Gives the Server Biz a Flat Tire in Q4

Infor Battles Customers in Court Over License Fees

As I See It: Isolation

Global IT Spending Barely Ahead of 2008; Some Regions Showing Strength

Four Hundred Stuff
DB2/400 Storage Engine for MySQL Now Available as Public Beta

PHP Saves Company Millions by Refurbishing Old ERP System

ManageEngine Goes On Demand with Data Center Tools

RSA Cracks Down on Security Threats with enVision 4.0

Kisco Adds Fax Support to WebReport/400

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

System i PTF Guide
March 7, 2009: Volume 11, Number 10

February 28, 2009: Volume 11, Number 9

February 21, 2009: Volume 11, Number 8

February 14, 2009: Volume 11, Number 7

February 7, 2009: Volume 11, Number 6

January 31, 2009: Volume 11, Number 5

TPM at The Register
IBM not worried about Cisco blades

IBM boasts of full 8Gb Fibre Channel for blades

EuroMidEastAfrica server biz tumbles

Intel 'Nehalem' Xeons poised for March 31 launch

AT&T wants to run your data center

Gartner: PC sales, except netbooks, to slump in 2009

Citrix taps VMLogix for fake server jukeboxing

Taiwan bails out memory makers

Lenovo erects Atom tower

Forrester: Fake servers like recessions

HP babysits small biz servers

Dell plays with virtual data centers

Server market gets second opinion on Q4

SGI lays off another 9 per cent

THIS ISSUE SPONSORED BY:

WorksRight Software
Profound Logic Software
Northeast User Groups Conference


Printer Friendly Version


TABLE OF CONTENTS
Looking for Commitment, Part 1

Treasury of new DB2 6.1 Features, Part 2: Grouping Sets and Super Groups

Admin Alert: Six Ways to Mess Up i5/OS User Profiles Security (And What To Do About It)

Four Hundred Guru

BACK ISSUES

From the IT Jungle Forums
ADO.NET/IBM.Data.DB2.iSeries/ iDB2Connection

Order by alias names

SQL procedure

Insert via Java

iSeries Access for Web

Mimix installation and configuration docs

EDI Inovis Programmer - Heavy Duty Problem Solver - Anytime




 
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-2009 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement