CREATE VIEW SYS.SYSUSERAUTH ( name, password, resourceauth, dbaauth, scheduleauth, user_group ) AS SELECT user_name, password, resourceauth, dbaauth, scheduleauth, user_group FROM SYS.SYSUSERPERM
Displays all the information in the table SYSUSERPERM except for user numbers. Since this view shows passwords, this system view does not have PUBLIC select permission. (All other system views have PUBLIC select permission.)