Neoview User Management Information (R2.4 SP1)

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.122739 ROLE.MGR 2009-02-27 13:14:11.122739 currmgr
2009-02-27 13:14:11.122739 currmgr
--- 1 row(s) selected.
14 User Status View