HP Neoview User Management Information HP Part Number: 533565-001 Published: September 2009 Edition: HP Neoview Release 2.
© Copyright 2009 Hewlett-Packard Development Company, L.P. Legal Notice Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license. The information contained herein is subject to change without notice.
Table of Contents About This Document.........................................................................................................5 Intended Audience.................................................................................................................................5 New and Changed Information in This Edition.....................................................................................5 Document Organization.....................................................................
List of Tables 3-1 4-1 4 VIEW HP_USER_LOGGING.USERINFO.....................................................................................13 VIEW HP_USER_LOGGING.USERLOG......................................................................................
About This Document This manual describes the logging of user-management actions on Neoview and the facilities available for monitoring such actions. Intended Audience This manual is for security administrators who will monitor user-management actions, such as adding and deleting users, granting or revoking roles, setting or changing passwords, on the Neoview platform. New and Changed Information in This Edition This manual is new.
• Management HP Database Manager (HPDM) Help topics that describe how to use the HP Database Manager client to monitor Online Help and manage a Neoview data warehousing platform. HP Database Manager (HPDM) Information for database administrators about how to monitor and manage User Guide a Neoview data warehousing platform using the HP Database Manager. Neoview Command Interface (NCI) Guide Information about using the HP Neoview Command Interface to run SQL statements interactively or from script files.
• ODBC Client Administrator Online Help Context-sensitive help topics that describe how to use the ODBC Data Source Administrator. README files for installing Connectivity products — README for the HP Neoview JDBC Type 4 Driver — README for the HP Neoview ODBC Driver for Windows — README for the HP Neoview ODBC Drivers for UNIX Reference Mapping Tables for Neoview Character Sets A hyperlinked collection of East Asian characters supported by Neoview character set functionality.
1 Introduction to User Management Information on Neoview This manual describes the facilities available for logging and monitoring user-management actions on the Neoview platform. These features are available only on Neoview Release 2.4 SP 1 and later releases. User Management on the Neoview Platform On the Neoview platform, a user with the role ROLE.
2 Initialization and Upgrade When you first upgrade the Neoview platform to include the user-management logging facility, a persistent process creates the required tables and views and initializes the tables with the names and role assignments of existing users. Certain columns of the tables are set to NULL; for example, a column that indicates when the user's role was last changed is populated with a value other than NULL only upon the first role change after the logging facility is initialized.
3 User Status View The User Status View (USERINFO) consists of one row per user. At any given time, this view reflects all users defined on the Neoview platform, except the super ID and the services ID. If a user is deleted, the user's row is deleted from this view, but changes pertaining to the user will still exist in the User Log View. Rows are in alphabetical order by USER_NAME. Neoview user names are unique across the platform. Timestamps reflect local time on the primary segment.
List All Users Who Have ROLE.MGR Privileges This query displays information for all users who currently have ROLE.MGR privileges. SQL>select * from HP_USER_LOGGING.USERINFO where ROLE_NAME = 'ROLE.MGR'; USER_NAME CREATION ROLE_NAME ROLE_MODIFIED ROLE_MOD_USER PWD_MODIFIED PWD_MOD_USER -------------------------------- -------------------------- ----------------- --------------------------------------------------------- -------------------------- -------------------------------user2 2009-02-27 13:14:11.
4 User Log View The User Log View (USERLOG) consists of one row for each user-management action. Rows are in chronological order by EVENT_TIME and, when timestamps are not unique, in alphabetical order by USER_NAME. Timestamps reflect local time on the primary segment. Column Definitions Each row consists of the following columns: Table 4-1 VIEW HP_USER_LOGGING.
Find Out When a Specified User was Deleted, and by Whom This query reveals which Neoview user deleted the Neoview user user8. SQL>select * from HP_USER_LOGGING.USERLOG where USER_NAME = 'user8' and USER_ACTION = 'User deleted'; EVENT_TIME USER_NAME USER_ACTION PREV_ROLE_NAME NEW_ROLE_NAME MODIFYING_USER -------------------------- -------------------------------- ------------------------------------------------------------------ ----------------- -------------------------------2009-02-27 13:14:12.
5 Limitations The User Management Information views record all changes made to user roles and passwords, whether those changes were initiated through DB Admin, a User Management Command, or an ODBC client. However, they: • • • • • Reflect only changes that have occurred since logging began, that is, since this feature was installed on the platform as part of platform installation or upgrade. Do not reflect creation and deletion of roles. Do not include rows pertaining to the super ID (super.
Index D DB Admin, 9 Documents, related information, 5 I Initialization, 11 L Limitations, 17 N NULL values, 11 P Passwords, changing, 9 Privileges Select, 9 R ROLE.
