Collection Contents Index SYSUSERAUTH system view SYSUSEROPTIONS system view pdf/chap16.pdf

Reference Manual
   CHAPTER 16. System Views     

SYSUSERLIST system view


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

Presents all of the information in SYSUSERAUTH except passwords.


Collection Contents Index SYSUSERAUTH system view SYSUSEROPTIONS system view pdf/chap16.pdf