Innovative Users Group May 2-5, 1998 Nashville, Tennessee
Reviewing Logins and Authorizations With a Pretty Neat Web Auditing Tool (H3/M3)
Tom Klingler and Kelly Sikora, Kent State University
Summary: Authorization information is extracted from the INNOPAC and loaded on a secure web site that allows administrators to view the data without needing access to the actual system tables. The project's primary goal is to empower department heads to review their own staffs' authorizations, and to help the systems office in a system-wide authorization review.
I.BACKGROUND AND NEED:
Kent library staff are widely dispersed at six libraries on the Kent campus and seven regional libraries throughout eastern Ohio. Managers do not have access to login and authorization data on the live system. A review and audit of authorizations is necessary for the sake of general system security.
II. OPPORTUNITY:
The tools and the staff became available.
III. GOALS:
Provide easy-to-read web pages to managers throughout the library system. These pages would allow the managers to review system authorization information. Accomplish this review effort without having to provide access to the actual system tables to all of the managers. Improve system security. Identify potential training needs. Prepare for the eventual assignment of additional Release 10 authorizations.
IV. DESIGN AND TOOLS:
White Rabbit Software -- KentLINK Information Reports -- Logins and Authorizations
** A. ProcommPlus32 Aspect scripts that run against KentLINK,
our INNOPAC.
-
scripts for login names and parameters and
authorizations, and a utility script
-
scripts generate text files for login names and parameters, and a hex dump for permissions data
** B. Visual Basic 5.0 code that converts and presents the
KentLINK data.
-
populates Access database tables
- generates some static html pages
- some VBScripts generate separate dynamic html pages
e.g. the permissions page
- goal: convert scripts to active server pages (ASP)
** C. Microsoft Internet Information Server (IIS)
- originally served from a desktop under Microsoft (PWS)
- recently moved into production under IIS Web Server on an NT 4.0 server
** D. Security managed by active server pages with VBScript
- limited to staff approved by systems staff
- these folks by default can also see circulation data
- intended scope limited to managers to help with
authorization review and audit
DEMO: White Rabbit Software -- KentLINK Information Reports -- Logins and Authorizations
Request Software: White Rabbit Software -- KentLINK Information Reports
Full presentation at
http://www.personal.kent.edu/~tk/wrauth.html