Neoview User Management Information (R2.4 SP1)

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.
If you query a view after initialization but before the first change in a given record, the value
displayed for each NULL column depends on the SQL tool you use. The following example,
generated from the Neoview Command Interface (NCI), lists the contents of the USERINFO view
immediately after platform initialization:
USER_NAME CREATION ROLE_NAME ROLE_MODIFIED
ROLE_MOD_USER PWD_MODIFIED PWD_MOD_USER
-------------------------------- -------------------------- ----------------- --------------------------
-------------------------------- -------------------------- --------------------------------
Fleischer_Debi NULL ROLE.USER NULL NULL
NULL NULL
Fleischer_DBA NULL ROLE.DBA NULL NULL
NULL NULL
DBA_01_DBA NULL ROLE.DBA NULL NULL
NULL NULL
ODBC_MANAGER NULL ROLE.MGR NULL NULL
NULL NULL
ODBC_TEST NULL ROLE.TEST NULL NULL
NULL NULL
SecurityAdmin NULL ROLE.MGR NULL NULL
NULL NULL
...
MauriceRavel NULL ROLE.USER NULL NULL
NULL NULL
GeraldPrice NULL ROLE.USER NULL NULL
NULL NULL
--- 275 row(s) selected.
The initialization process creates the following views in the schema HP_USER_LOGGING on
the primary segment of the Neoview platform:
HP_USER_LOGGING.USERINFO
HP_USER_LOGGING.USERLOG
These views are described in detail in the next two chapters.
NOTE: If you upgrade the Neoview platform after the logging facility is installed—for example,
if you upgrade from one Neoview release or service pack to the next—the USERINFO and
USERLOG tables and views might be enhanced, but all existing user-management data is
preserved.
11