Reference Manual
   CHAPTER 16. System Views     

SYSUSERAUTH system view

CREATE VIEW SYS.SYSUSERAUTH ( name, password,    resourceauth, dbaauth, scheduleauth, user_group )
AS
SELECT user_name, password, resourceauth,
      dbaauth, scheduleauth, user_group
FROM SYS.SYSUSERPERM

Presents all the information in the table SYSUSERPERM except for user numbers. Because this view shows passwords, this system view does not have PUBLIC select permission. (All other system views have PUBLIC select permission.)